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

"csm" wrote in message
...
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?

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


"csm" wrote:

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?

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

"ShaneDevenshire" wrote in
message ...
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


"csm" wrote:

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?

Well, duh. Thanks.

"Peo Sjoblom" wrote:

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

"ShaneDevenshire" wrote in
message ...
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


"csm" wrote:

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?