inputting American dates into an English workbook
 

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?

inputting American dates into an English workbook
 

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?

inputting American dates into an English workbook
 

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