Dates

  • Thread starter Thread starter mandingo
  • Start date Start date
M

mandingo

Hi

I use Excel 2002 on a Win2k machine at work. At home I use an earlier version of Excel (can't remeber of-hand what that is) on Win98.

When ever I bring home some Excel files from work, the dates are changed to American date (mm/dd/yy), but my Win98 system is definitly setup for UK.

Can anyone tell me why this might be happening?

thanks
m
 
I'd look once more at your windows regional settings.

Windows start button|settings|control panel|regional settings applet

Date tab.
Double check that short date format.

And if that didn't help. Try formatting one of those cells as:

mmmm dd, yyyy

do you get the date/format you expect?

(maybe the dates are really text???)
 
You must log in or register to reply here.

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

Preserving date format 1
date format 1
Date format getting muddled 3
Weird date format problem 2
Count Between dates 11
In excel when inputting dates 10/4/04 (10/april/04) data converts. 1
Date formatting from user form to worksheet 6
Date stored as Text 3

Back
Top