| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel. decimal convert date
when i use decimal seperator dot "." it automatically converts it to a date
entry. eg, i enter 1.5 and it converts it to 01.May. I want to disable this feature. regards |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel. decimal convert date
Excel is probably just following your Windows regional settings as it what
character is the date separator. Go into Control Panel and change it to "/" or "-". -- Jim "gt" wrote in message ... | when i use decimal seperator dot "." it automatically converts it to a date | entry. eg, i enter 1.5 and it converts it to 01.May. I want to disable this | feature. regards |
| 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) | |||
| Excel adds phantom decimal places: why? | Excel Discussion (Misc queries) | |||
| how do I convert a UK date to a US date in excel? | Excel Discussion (Misc queries) | |||
Linear Mode
