Date Formats

D

david d

I am using Excel XP. I have imported a chart from a word processing program,
not Word, into Excel. Everything works find , except for some of the date
entries. I have two columns of dates, one for birth and one for death. In
each column I several entries that will not reform. They show to be either
'general' or 'custom'. I have made several attempts to reformat them to
'date' but they will change

Any Ideas?
 
S

Sheeloo

Try the TRIM formula on them...
If it does not work then paste a few examples here...
 
R

Ron Rosenfeld

I am using Excel XP. I have imported a chart from a word processing program,
not Word, into Excel. Everything works find , except for some of the date
entries. I have two columns of dates, one for birth and one for death. In
each column I several entries that will not reform. They show to be either
'general' or 'custom'. I have made several attempts to reformat them to
'date' but they will change

Any Ideas?
Click to expand...

They are probably there as text, and possibly with non-printing characters or
<space>'s included.

Try the Data/Text-to-columns wizard, selecting only the one column, and the
appropriate date format for the source data.
--ron
 
Top