98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Entering numbers
Entering numbers
Resolved · Low Priority · Version 2003
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
Tue 13 May 2008, 06:00Trainer Tracy said...
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
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. |
Excel tip:Repeat actionThe F4 key will usually repeat your last action. e.g. delete a row, then select another row and press F4 to delete again. |
