How do I set dates to ISO INternational?

C

Charlotte

I recently upgraded to Office 2007. I can't find date conversion to
International ISO date format any more (20020101, e.g.)

What am I missing?
 
C

Chip Pearson

Use, in VBA,

S = Format(TheDate,"yyyymmdd")

or as a formula,
=TEXT(TheDate,"yyyymmdd")

or as a custom number format
yyyymmdd



--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
C

Charlotte

Thanks, I had just figured out the custom option. But it's an extra few
steps from just picking it as the date option in Excel 2003. Bummer.
 
B

Bernard Liengme

Have you tried changing your Windows Regional Setting - that's where Excel
picks it default date format from
best wishes
 
Top