Autocorrection

G

Guest

Hello, I am a University student and am trying to construct a life table graph and need some help with Excel. I need to enter several age groups into a column eg 0-4, 5-9, 10-14. 15-19 and so on.

My problem is that when I type 5-9 into the cell, Excel autocorrects it to say 5th Sept. I can't seem to find a way to turn this 'autocorrect' feature off. I have already used the 'Help' Wizard and have turned off all autocorrect functions in Excel and yet this continues to occur

Any help is greatly appreciated

Andrew
 
D

Debra Dalgleish

Type an apostrophe at the start of the string, e.g. '5-9.
The apostrophe won't be visible after you press the Enter key.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top