| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to get Excel to stop formatting text as a date?
Is there any way to make Excel stop automatically formatting text as a date?
Specifically I want to be able to type 4-6 without it converting it to a date, and I don't want to have to type an apostrophe before everything. Is there a way to just turn this auto formatting off, besides formatting the cells as text before hand? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is it possible to get Excel to stop formatting text as a date?
No
-- Regards, Peo Sjoblom "PeteeWJ" wrote in message ... Is there any way to make Excel stop automatically formatting text as a date? Specifically I want to be able to type 4-6 without it converting it to a date, and I don't want to have to type an apostrophe before everything. Is there a way to just turn this auto formatting off, besides formatting the cells as text before hand? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is it possible to get Excel to stop formatting text as a date?
Those are your only 2 options:
Precede with an apostrophe or pre-format as TEXT -- Biff Microsoft Excel MVP "PeteeWJ" wrote in message ... Is there any way to make Excel stop automatically formatting text as a date? Specifically I want to be able to type 4-6 without it converting it to a date, and I don't want to have to type an apostrophe before everything. Is there a way to just turn this auto formatting off, besides formatting the cells as text before hand? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| import /paste -stop automatic conversion of text 05-12345 to date | Excel Discussion (Misc queries) | |||
| How do I get Excel to stop auto-formatting? | Excel Discussion (Misc queries) | |||
| how to stop excel formatting | Excel Discussion (Misc queries) | |||
| How do I stop Excel auto formatting the text 3-4 as 04 Apr? | Excel Discussion (Misc queries) | |||
| How to stop text changing to date | Excel Discussion (Misc queries) | |||
Linear Mode
