| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function or formula to convert "text" month to number of month? | Excel Discussion (Misc queries) | |||
| function to fill all days of month to end of month | Excel Worksheet Functions | |||
| function to fill all days of month to end of month | Excel Worksheet Functions | |||
| When using MONTH function on Blank Cell!! Returns Month=Jan! | Excel Discussion (Misc queries) | |||
| =Month function in Excel gives incorrect month | New Users to Excel | |||
Hybrid Mode
