Dates
Make sure your windows short date setting (under control panel|regional
settings) is set for dmy.
Then try selecting your range and
edit|replace
what: / (slash)
with: / (slash)
replace all
Excel will see it as a change to the cell and see that it's a date.
mhd143 wrote:
I have a problem with dates in two columns see below.
Basically all cells are formatted at dd/mm/yyyy but only those that are
right justified seem to be correctly formatted as dates.
The only way i can find to right justify them(so they are proper dates) is
by double clicking in the cells then pressing enter.
04/03/2006 04/03/2006
04/06/2006 04/06/2006
04/10/2006 04/10/2006
13/04/2006 13/04/2006
16/03/2006 17/03/2006
20/03/2006 31/03/2006
Is there any way to automate what i'm doing manaually please?
--
Dave Peterson
|