Turning off the month function
 

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!

Turning off the month function
 

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

"emd" wrote:

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!

Turning off the month function
 

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


"emd" wrote:

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!

Turning off the month function
 

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

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

"emd" wrote:

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!