Date Conversion
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 |
Date Conversion
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 |
Date Conversion
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 |
Date Conversion
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? |
All times are GMT +1. The time now is 12:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com