Previous Topic Next Topic

Excel 2007

Closed
Cameron - Aug 17, 2010 at 03:01 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 18, 2010 at 12:06 AM
Hello,

I have a spread that has a column for dates however my boss just typed the date, with no formatting in that cell. The formatting is "General". I want to change all of the dates to the format mm/dd/yy where now they are January 1, 2010. Remember there is no date formatting in that cell. I want Excel to change it for me so I don't have to go through and retype over 1000 dates!



Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Aug 18, 2010 at 12:06 AM
Why not format the column to the right format ? You dont have to type

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses