| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stop auto conversion of numbers to a date?
I type in 9-5 and Excel automatically changes my entry to 9-May. I've tried
to stop it using Autoformat but it hasn't worked. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I stop auto conversion of numbers to a date?
Format the cell as Text before entering any information into it.
-- Gary''s Student - gsnu200756 "L" wrote: I type in 9-5 and Excel automatically changes my entry to 9-May. I've tried to stop it using Autoformat but it hasn't worked. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I stop auto conversion of numbers to a date?
L
Preceed your entry with an apostrophe or formate the cells as text. Mike Rogers "L" wrote: I type in 9-5 and Excel automatically changes my entry to 9-May. I've tried to stop it using Autoformat but it hasn't worked. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop date conversion in Excel when pasting | Excel Discussion (Misc queries) | |||
| stop excel from auto editing my numbers | Excel Discussion (Misc queries) | |||
| On File open - how to stop conversion of postcodes to numbers | Excel Worksheet Functions | |||
| import /paste -stop automatic conversion of text 05-12345 to date | Excel Discussion (Misc queries) | |||
| How do I stop Excel from changing numbers into a date? | Excel Discussion (Misc queries) | |||
Hybrid Mode
