Thread: [Solved] Help needed in changing date format
View Single Post
 
Old 07-24-2015, 01:54 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,362
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Your cells are formatted as text, not as dates; hence the content is text, not dates (dates would be right-aligned).

First, change the cell format to your required date format for all the dates.
Next, input 1 into any other cell, then cut that to put it in the clipboard.
Finally, select all the dates and choose Paste Special>Values>Multiply>OK.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote