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
