Date Question

  • Thread starter Thread starter kwamekyi
  • Start date Start date
K

kwamekyi

I am finding it very difficult to change a series of American date format to
British dates format in Microsoft excel 2003 worksheet. Help.
 
Have your dates come in as text? Please give more details, including
examples of the dates you import and the problems you are having.

Pete
 
You don't explain what difficulty you are having but on the assumption they
are correctly formatted dates it should be as simple as applying a custom
format of

dd/mm/yyyy for UK

or

mm/dd/yyyy for USA.

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing the date format 1
What Does It Mean To Be British? 3
Date Format in Spreadsheet different from menu bar how to fix? 4
Problem with 'Find' 5
Preserving date format 1
How can I change Excel to use the British date system? 3
Date format getting muddled 3
Columns formatted As Dates Are Exported as a Number to Text 1

Back
Top