Is there a way to enter dates American style (e.g. 4/25/2007 rather than the
English 25/4/2007) into Excel and be understood without changing my regional
settings?

Hi Smallweed,

Assuming that your regional settinggs are UK settings,
you can certainly format UK style dates to appear in
US format, but these will always be interpreted as the
underlying UK date.

If your intention is to enter dates in US format- perhaps
copying them from a US document - and have Excel
interpret them as UK dates, try inputting the dates as
text values.

Then:, with the 'US' dates selected:

Data | Text to Columns | Next | Next |
Select the 'Date' option | select the 'MDY' option


---
Regards,
Norman


"Smallweed" wrote in message
...
Is there a way to enter dates American style (e.g. 4/25/2007 rather than
the
English 25/4/2007) into Excel and be understood without changing my
regional
settings?

Not if you want to continue to use the short date format.

Smallweed wrote:

Is there a way to enter dates American style (e.g. 4/25/2007 rather than the
English 25/4/2007) into Excel and be understood without changing my regional
settings?

--

Dave Peterson