Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Does anyone have any suggestions on how to read this date format?
12/11/2009, which format is mm/dd/yyyy, but excel 2003 cannot able to recognize it, when I apply the function FIND("/",H22,1), and it returns #Value!, where H22 contains 12/11/2009. Does anyone have any suggestions on how to solve this issue? Thanks in advance for any suggestions Eric |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
permanent conversion of 1904 date format to 1900 date format | Excel Worksheet Functions | |||
How can I format a cell to read a blood pressure? | Excel Discussion (Misc queries) | |||
How do you format a cell to read text only? | Excel Discussion (Misc queries) | |||
See a number, read a date | Excel Discussion (Misc queries) | |||
format a cell to read zero for any negative value | Excel Discussion (Misc queries) |