Forum home » Delegate support and help forum » Microsoft Excel Training and help » Entering numbers
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Entering numbers
Resolved · Low Priority · Version 2003
Reply Mon 12 May 2008, 16:31Delegate Susan said...
Susan has attended:
Powerpoint Introduction course
Excel Introduction course
Entering numbers
why do I sometime have to enter an ' before entering a number, if I don't the format is automatically changed
For upcoming training course dates see: Pricing & availability
RE: entering numbers
Good question! When typing in numbers Excel assumes you want to be able to add them up, so it defauls to formatting them to number style. By putting a ' in you are overriding that setting and able to type the number in as text.
Hope that helps
Tracy
|