Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Changing Excel Formats not readily appearing
- Thread starter whoffman
- Start date
Sounds like what you are pasting in is being treated as text
Enter a 1 into another cell
Select that cell and press CTRL+C (copy)
Select your dates data range and go to
Edit>PasteSpecial
Select Values & Multiply
This should convert them to values
You will see date serial numbers in the cells - don't be alarmed - just format as whatever date format you want all should be fine Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes
Enter a 1 into another cell
Select that cell and press CTRL+C (copy)
Select your dates data range and go to
Edit>PasteSpecial
Select Values & Multiply
This should convert them to values
You will see date serial numbers in the cells - don't be alarmed - just format as whatever date format you want all should be fine Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes
- Status