Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FormatDate
There is a column in a spreadsheet with the dates likes this 20030630, I
need to have them 6/30/03. How can I get this output? I am not sure, but I think they are in a text format. I have another column with 16 digits and when I save it as a csv it drops the far right digit and replaces it with a zero. How can this be avoided? I am using Excel 2000. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
FormatDate
Use a formula like
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)) -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "jb" wrote in message ... There is a column in a spreadsheet with the dates likes this 20030630, I need to have them 6/30/03. How can I get this output? I am not sure, but I think they are in a text format. I have another column with 16 digits and when I save it as a csv it drops the far right digit and replaces it with a zero. How can this be avoided? I am using Excel 2000. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|