| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Entering 3.9 - Excel means that is Date how tu turn off it
Hello,
I'm entering in cell "3.9" and Excel automaticaly recognizes as date "2007.03.09".. This is bad.. How TURN OFF this feature.. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Entering 3.9 - Excel means that is Date how tu turn off it
That sounds like a mixture of having the cell formatted to date before you
enter the number, and the date separator in Windows/ Regional Options being set to full stop rather than a slant. Try chaging the cell format to General before you put in the data, and/or change your Windows date separator to a slant. -- David Biddulph "Krapas" wrote in message ... Hello, I'm entering in cell "3.9" and Excel automaticaly recognizes as date "2007.03.09".. This is bad.. How TURN OFF this feature.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel date scheduling not msProject | Excel Worksheet Functions | |||
| Add a formated date button for Excel 2002 tool bar | Excel Discussion (Misc queries) | |||
| Excel date format issue | Excel Discussion (Misc queries) | |||
| How do I turn off the Auto Date function in Excel | Excel Worksheet Functions | |||
| After concatenating data, how do I get Excel to recognise date? | Excel Discussion (Misc queries) | |||
Linear Mode
