| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date format in cell
I am trying to put a date in a cell, but the cell keeps formatting the
numbers with a = sign before them turning it into a formula. How can I stop it from doing this? I've already cleared all formats from the cell. 1/1/09 turns into =1/1/9 with a result of 0.1111111111 Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date format in cell
Check this setting:
ToolsOptionsTransition tabTransition formula entry Uncheck that settingOK -- Biff Microsoft Excel MVP "klappin" wrote in message ... I am trying to put a date in a cell, but the cell keeps formatting the numbers with a = sign before them turning it into a formula. How can I stop it from doing this? I've already cleared all formats from the cell. 1/1/09 turns into =1/1/9 with a result of 0.1111111111 Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date format in cell
Thanks!
"T. Valko" wrote: Check this setting: ToolsOptionsTransition tabTransition formula entry Uncheck that settingOK -- Biff Microsoft Excel MVP "klappin" wrote in message ... I am trying to put a date in a cell, but the cell keeps formatting the numbers with a = sign before them turning it into a formula. How can I stop it from doing this? I've already cleared all formats from the cell. 1/1/09 turns into =1/1/9 with a result of 0.1111111111 Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date format in cell
You're welcome!
-- Biff Microsoft Excel MVP "klappin" wrote in message ... Thanks! "T. Valko" wrote: Check this setting: ToolsOptionsTransition tabTransition formula entry Uncheck that settingOK -- Biff Microsoft Excel MVP "klappin" wrote in message ... I am trying to put a date in a cell, but the cell keeps formatting the numbers with a = sign before them turning it into a formula. How can I stop it from doing this? I've already cleared all formats from the cell. 1/1/09 turns into =1/1/9 with a result of 0.1111111111 Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format date in a cell | Excel Discussion (Misc queries) | |||
| How can I get date of file creation to XLS cell in date format? | Excel Worksheet Functions | |||
| How do I format a cell to a date format? | Excel Discussion (Misc queries) | |||
| Date format does not appear in cell | Excel Discussion (Misc queries) | |||
| cell format for date/time in same cell excel 2003 | Excel Worksheet Functions | |||
Linear Mode
