| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to read this date format?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to read this date format?
It is in DD/MM/YYYY Format.
=TEXT(H22,"DD")&" DAYS "&TEXT(H22,"MM")&" MONTHS "&TEXT(H22,"YYYY")&" YEARS" Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Eric" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to read this date format?
12/11/2009 is a valid date as is stored by excel as the number 40158. (Try
changing the format to General or number format). This is only displayed as date format when you format to date. Read out this "must read" page from Chip on how excel stores date and time http://www.cpearson.com/excel/datetime.htm Someone here should be able to help; if you can elaborate what you are trying to accomplish -- Jacob "Eric" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Hybrid Mode
