column format won't change???

[jdog089]

After copying numerous sheets of dates where the format was (m/d/yy)
1/1/03, into a master sheet - i now want to change the format to
(m/d/yyyy) 1/1/2003.

But the column format won't change, even if i just change the format on
a single cell. The format only changes if you "edit" the cell.

You dont even have to change anything, just double-click and then click
out, and it changes to the yyyy format - I'd do it by hand, but i have
about 11000 records to change.

right now im hitting F2 and Enter about a million times as they change
1 at a time.

Any suggestions?

thx



------------------------------------------------


-- View and post Excel related usenet messages directly from http://www.ExcelForum.com
at http://www.ExcelTip.com/
------------------------------------------------

 

[Davi]

Your "date" data is currently formatted as text. Changing the cell display
format won't change the data format. To change the data format, run a Value
formula "=Value(A1)" against your dates. Remove the formula (Copy, Paste
Special, Formulas) and apply the correct cell format.