Date Formatting problem

  • Thread starter Thread starter Rick Prater
  • Start date Start date
R

Rick Prater

I have a excel (professional xp). I have a problem
formatting a text field into a date field. When I format
the field nothing happens, until I double click on the
field and then it formats. The problem is that I have
over 8000 lines and I can't do this for every field.
Does anyone have any ideas?

Thanks,
Rick
 
Rick

Enter 1 in a blank cell and copy it. Highlight the 'dates' and Edit>Paste
special...>Values+Multiply. With them still highlighted, reformat them as
Date (Format>Cells...Number.Date). Don't worry that they all look like
numbers before formatting. That's how Excel stores dates
 
That worked!! Thanks!
-----Original Message-----
Rick

Enter 1 in a blank cell and copy it. Highlight the 'dates' and Edit>Paste
special...>Values+Multiply. With them still highlighted, reformat them as
Date (Format>Cells...Number.Date). Don't worry that they all look like
numbers before formatting. That's how Excel stores dates

--
HTH
Nick Hodge
Southampton, England
(e-mail address removed)





.
Click to expand...
 
Back
Top