Turning off the month function

  • Thread starter Thread starter emd
  • Start date Start date
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!
 
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
 
precede with '8-45 it will treat as text
or
preformat cell as text then enter 8-45
 
Enter a ' before entering the number...like this
'8-45

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