E
Eva Shanley
I'm re-writing a Lotus 123 spreadsheet to Excel; the
spreadsheet creates an output file that feeds another
program. Dates in the 123 file keyed as 02/12/04 are
picked up by 2 other columns; the 1st uses DATESTRING to
convert the date number into text (date is then a text
type still showing as 02/12/04). The 2nd column uses @LEFT
(AH6,2)&@MID(AH6,3,2)&@RIGHT(AH6,2)to get just the numbers
with no slashes (021204). I cannot find any function in
Excel to do the DATESTRING, so finally ended up formatting
the cell as Custom mmddyy which did get rid of the
slashes. However, the type is still a number instead of
text and regardless of whether it will feed DataCom or
not, I'd like to know if there is a way to do the
DATESTRING properly so it formats as text. Thanks, I
appreciate all your help.
spreadsheet creates an output file that feeds another
program. Dates in the 123 file keyed as 02/12/04 are
picked up by 2 other columns; the 1st uses DATESTRING to
convert the date number into text (date is then a text
type still showing as 02/12/04). The 2nd column uses @LEFT
(AH6,2)&@MID(AH6,3,2)&@RIGHT(AH6,2)to get just the numbers
with no slashes (021204). I cannot find any function in
Excel to do the DATESTRING, so finally ended up formatting
the cell as Custom mmddyy which did get rid of the
slashes. However, the type is still a number instead of
text and regardless of whether it will feed DataCom or
not, I'd like to know if there is a way to do the
DATESTRING properly so it formats as text. Thanks, I
appreciate all your help.