How do I re-format the content in populated cells in Excel?

Z

Zoey

I have a column of dates that I want to switch to another date format. So far
I know how to do that only by formatting the column, then double-clicking on
a single cell, clicking on the column header, and repeating this action with
each subsequent cell... There has to be a better way, no?
 
D

David Biddulph

There has to be a better way, Yes!

Select either the whole column or the range of cells. Then Format/ Cells/
Number/ ...
 
G

Gary''s Student

1. Select all the cells in the column
2. Format > Cells... > Number > Date and pick the right format
It will be applied to ALL the cells in the column in one swell foop!
 
K

KC Rippstein hotmail com>

When you formatted the column, the dates should have changed if they were in
numeric format. It sounds like you're starting with dates in text format (it
can only format numbers as dates, not text). So...

go off to the right side of your worksheet to any blank cell outside your
data range and copy it to your clipboard; now highlight all your dates and go
to Edit > Paste Special > Add; hit Escape and you should see your dates are
now in numeric format and ready for Excel to apply date formatting to them.
 
Top