Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Excel to not automatically convert text to date
Is there a way to configure excel to not automatically
convert text that looks like a date into a date format? For example, I want to be able to type the text string "August 3" into a cell and expect it to remain as "August 3". Excel is always converting this into date format automatically as "3-Aug". I know that if you type it as 'August 3 then it won't convert but is there any other way than this? thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert text to number automatically | Excel Discussion (Misc queries) | |||
Excel - convert dates to text but appear as a date format | Excel Discussion (Misc queries) | |||
Turn off Automatically convert number to date | Excel Discussion (Misc queries) | |||
can i convert numbers to text automatically | Excel Worksheet Functions | |||
How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) |