inputting American dates into an English workbook

[Guest]

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?

 

[Norman Jones]

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

 

[Dave Peterson]

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