Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to date format
Hi everyone, In our system generated .CSV file, one column is the date in the format of YYYYMMDD, for example 20060301. I want to format this column to this date format, 3/1/2006, but I can't. It just gives me a bunch of #'s. I copied the column to another sheet but got the same result. -- ledzepe ------------------------------------------------------------------------ ledzepe's Profile: http://www.excelforum.com/member.php...o&userid=25207 View this thread: http://www.excelforum.com/showthread...hreadid=517978 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to date format
ledzepe
if the text is in cell A9 =DATE(LEFT(A9,4),MID(A9,5,2),RIGHT(A9,2)) Regards Trevor "ledzepe" wrote in message ... Hi everyone, In our system generated .CSV file, one column is the date in the format of YYYYMMDD, for example 20060301. I want to format this column to this date format, 3/1/2006, but I can't. It just gives me a bunch of #'s. I copied the column to another sheet but got the same result. -- ledzepe ------------------------------------------------------------------------ ledzepe's Profile: http://www.excelforum.com/member.php...o&userid=25207 View this thread: http://www.excelforum.com/showthread...hreadid=517978 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to date format
Select the column you want to change.
Select Data-Text to columns Select Delimited and click next Click next again Select Date and choose YMD Click Finish All cells in that column containing a number like 20060301 should now be changed to a date like 3/1/2006. "ledzepe" wrote: Hi everyone, In our system generated .CSV file, one column is the date in the format of YYYYMMDD, for example 20060301. I want to format this column to this date format, 3/1/2006, but I can't. It just gives me a bunch of #'s. I copied the column to another sheet but got the same result. -- ledzepe ------------------------------------------------------------------------ ledzepe's Profile: http://www.excelforum.com/member.php...o&userid=25207 View this thread: http://www.excelforum.com/showthread...hreadid=517978 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Date format not correct when you convert a CSV text file in Excel | Excel Discussion (Misc queries) | |||
Date Format Problems?? | Excel Discussion (Misc queries) | |||
MS Query Date Format | Excel Discussion (Misc queries) | |||
Date format within a text syntex? | Excel Worksheet Functions |