Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date conversion
I have a database with date in the following format:
"200209021600" so 2 september 2002 16:00 hr I cannot figure out how to convert this text to the actual date and time Who can help me? Thanks in advance Kristiaan |
#2
|
|||
|
|||
Hi Kristiaaan,
This formula works for me: =--(TEXT(A1,"0000-00-00 00\:00")) Don't forget to format the cell as date. Regards, KL "Kristiaaan" wrote in message ... I have a database with date in the following format: "200209021600" so 2 september 2002 16:00 hr I cannot figure out how to convert this text to the actual date and time Who can help me? Thanks in advance Kristiaan |
#3
|
|||
|
|||
On Sat, 30 Jul 2005 02:14:45 +0200, "KL" wrote:
This formula works for me: =--(TEXT(A1,"0000-00-00 00\:00")) Don't forget to format the cell as date. KL- What are the two hyphens for at the beginning of this formula? MP- -- "Learning is a behavior that results from consequences." B.F. Skinner |
#4
|
|||
|
|||
They are coercing text into value as if I were using the function VALUE.
Regards, KL "Mangus Pyke" wrote in message ... On Sat, 30 Jul 2005 02:14:45 +0200, "KL" wrote: This formula works for me: =--(TEXT(A1,"0000-00-00 00\:00")) Don't forget to format the cell as date. KL- What are the two hyphens for at the beginning of this formula? MP- -- "Learning is a behavior that results from consequences." B.F. Skinner |
#5
|
|||
|
|||
On Sat, 30 Jul 2005 03:10:45 +0200, "KL" wrote:
They are coercing text into value as if I were using the function VALUE. KL: Thanks for the response.. while I don't truly understand, that gives me a starting point. My Excel 2003 Bible and I will go spend a few moments of quality time with the VALUE function. Thanks much! MP- -- "Learning is a behavior that results from consequences." B.F. Skinner |
#6
|
|||
|
|||
Hi KL,
Wow, I couldn't make that up myself. You really helped me out, thanks! Now I can finally make a nice graph of my data... let's see what it tells me... Regards, Kristiaan "KL" wrote: Hi Kristiaaan, This formula works for me: =--(TEXT(A1,"0000-00-00 00\:00")) Don't forget to format the cell as date. Regards, KL "Kristiaaan" wrote in message ... I have a database with date in the following format: "200209021600" so 2 september 2002 16:00 hr I cannot figure out how to convert this text to the actual date and time Who can help me? Thanks in advance Kristiaan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Format - Conversion | Excel Discussion (Misc queries) | |||
Date Conversion | Excel Worksheet Functions | |||
Date conversion issue "^" symbol | Excel Discussion (Misc queries) | |||
Date Conversion | Excel Discussion (Misc queries) | |||
unwanted number to date conversion while pasting data from web | Excel Worksheet Functions |