Convert text to columns

  • Thread starter Thread starter csm
  • Start date Start date
C

csm

If I have a date such as 4/10/1956 and I want to convert it to three columns,
how do I get it to come out correctly? Each time I do it, the second and
third columns are correct and the first column says 1/4/1900. What am I
doing wrong?
 
Change the format to general, you still have date format which it shouldn't
be

--


Regards,


Peo Sjoblom
 
If you have dates in column A in the format 4/10/1956 the best way to enter
the month, day, year in separate columns - highlight the original dates and
choose Data, Text to Columns, Delimited, Next, type / as the custom
delimiter, click Next set the destination to the cell where you want the
first month output to appear, and click finish. If the target cells were
formatted to general everything will be fine.

-
Cheers,
Shane Devenshire
 
I bet that's what the OP did or else it would probably
be hard to get 1/4/1900 in first cell, he/she only deeds to change
the format in the first cell from date to general

--


Regards,


Peo Sjoblom
 
Well, duh. Thanks.

Peo Sjoblom said:
I bet that's what the OP did or else it would probably
be hard to get 1/4/1900 in first cell, he/she only deeds to change
the format in the first cell from date to general

--


Regards,


Peo Sjoblom
Click to expand...
 
Back
Top