Help Please,

I am a beginer in Excel and have a spreadsheet with USA date's in it that I
need to convert to UK date format. Is there a simple solution, my system is
set up as UK.
--
Pat

select a cell which has, say, 12/25/2008 in it:

Format Cells... Number Custom dd/mm/yyyy
--
Gary''s Student - gsnu200772


"Pat" wrote:

Help Please,

I am a beginer in Excel and have a spreadsheet with USA date's in it that I
need to convert to UK date format. Is there a simple solution, my system is
set up as UK.
--
Pat

Hi Gary that does not work, stays in the same format.
I have 10/05/2007 when I need it to be 05/10/2007 can anybody help?
--
Pat


"Gary''s Student" wrote:

select a cell which has, say, 12/25/2008 in it:

Format Cells... Number Custom dd/mm/yyyy
--
Gary''s Student - gsnu200772


"Pat" wrote:

Help Please,

I am a beginer in Excel and have a spreadsheet with USA date's in it that I
need to convert to UK date format. Is there a simple solution, my system is
set up as UK.
--
Pat

USA dates are usually m/d/yy

Your date may be text.

Try DataText to ColumnsNextNextDate Column FormatDate and MDY

Then format to d/m/yy


Gord Dibben MS Excel MVP

On Sat, 8 Mar 2008 14:36:04 -0800, Pat wrote:

Hi Gary that does not work, stays in the same format.
I have 10/05/2007 when I need it to be 05/10/2007 can anybody help?