Turning off the month function

E

emd

Excel is converting my numbers into months (e.g., "8" becomes "Aug" when in
this format: 8-45). In that example, I do NOT mean August, 1945; it's a page
number. How do I turn off this function? I've looked everywhere for an answer!
 
F

FSt1

hi
this is excel being helpful. only way i know of is to preformat the cell as
text or preceed the entry with an apostrophe.

Regards
FSt1
 
T

Teethless mama

precede with '8-45 it will treat as text
or
preformat cell as text then enter 8-45
 
S

Sheeloo

Enter a ' before entering the number...like this
'8-45

or format the cells as TEXT before entering the numbers...
 
Top