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 |
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 |
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 |
All times are GMT +1. The time now is 11:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com