| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
why the date convert to number when i choose formulas from options
Dear,
when i choose tools,option,view,formula the date in date formatted cells converted to a number, why? i am working in excel 2003 thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
why the date convert to number when i choose formulas from options
I guess it takes away all formatting and the underlying value is shown,
excel dates are days since Jan 0 1900 where 1 is one day and today would be 38812, if that is disturbing to you enter any date preceded with an apostrophe however that will make the date text -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Musab Saleh" <Musab wrote in message ... Dear, when i choose tools,option,view,formula the date in date formatted cells converted to a number, why? i am working in excel 2003 thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
| Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
| Arrays Take too long. VERY HARD QUESTION. my head hurts : / | Excel Worksheet Functions | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
| Convert week number into calendar month? | Excel Worksheet Functions | |||
Linear Mode
