Based in the UK and using Excel/97 I have the following formula,
=Start!E12 & " / Date: " & TEXT(Start!E8,"dd-mmm-yyyy"). This
evaluates correctly to show the name of the person creating the
spreadsheet (from Start!E12) and the date it was created (from
Start!E8), however a colleague based in Zurich, using Excel/2000 only
sees the name of the person and the date displays as dd-00-yyyy.
After much digging, we finally found that we needed to set the
formatting to TT-MMM-JJJJ as German for Day = Tag and for Year = Jahr.
I am now left with the problem of having to find a solution for
multiple nationalities as this spreadsheet will be used in UK, USA,
Germany, Switzerland, Italy and Spain, all of whom have their own words
for Day, Month and Year.
Can anyone offer me an idea of where to start with this one, formula of
VB, I don't mind, just so long as I don't have to maintain 4 or more
versions of the spreadsheet. Is there a way, perhaps, of finding what
the Language setting is and then coding accordingly ? I really am open
to suggestions.
Regards
Fred
Bookmarks