Hi Fred,

I would use a UDF, as VBA works in one format


Function MyDate(rng As Range, dte As Range, dateformat As String)
MyDate = rng.Value & " / Date: " & Format(dte, dateformat)
End Function

and use like so

=mydate(Start!E12 ,Start!E8,"dd mmm yyyy")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Fred" wrote in message
ups.com...
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