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?

Hi,

Try find & replace / with /. You will need to expand the options so you can
uncheck 'Match entire cell contents'.

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"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?

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