Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() hello, I have a number that is actually a date, now i want to convert this number back to a date, i have tried to do that with cell formats en with the macro recorder, but the value in the cell remains the number until you click on it several times. It must be converted at once because several functions are depending on it. Regards, Niek ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting number into proper date format | Excel Discussion (Misc queries) | |||
Converting Number to Date | Excel Discussion (Misc queries) | |||
Converting a number to a date | Excel Discussion (Misc queries) | |||
converting date to number | Excel Worksheet Functions | |||
converting 8-digit number to date | Excel Discussion (Misc queries) |