How do I set dates to ISO INternational?
 

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?

How do I set dates to ISO INternational?
 

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)






"Charlotte" wrote in message
...
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?

How do I set dates to ISO INternational?
 

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.

"Chip Pearson" wrote:

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)






"Charlotte" wrote in message
...
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?

How do I set dates to ISO INternational?
 

Have you tried changing your Windows Regional Setting - that's where Excel
picks it default date format from
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Charlotte" wrote in message
...
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.

"Chip Pearson" wrote:

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)






"Charlotte" wrote in message
...
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?