Date Format

[Fable]

Greetings,

I got a workbook that was done on English PC, but the ender user wil
be using thier PC with Spanish setting, the issue is the date format i
English is (mm/dd/yy) MONTH, DAY, YEAR but in Spainsh it's (dd/mm/aa
DIA, MES, ANO . . . the main problem is the "YY" (YEAR) vs "AA" (ANO
if a spanish PC is used and a date is entered it will cuase a erro
like this "JAN-01-YYYY".

1- If there a way to force an English date format in this workbook an
turn back Spanish.

2- Is there a VB solution to this.

3- I should I resort to a DATE forumla, e.g. drop box (mm/dd/yy)

Thanking you in advance

 

[Niek Otten]

Hi Fable,

Excel will "convert" the date automatically. Internally, it stores a number
(of days since 1-1-1900); it displays it according to the local date
settings.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel