How do I set dates to ISO INternational?

  • Thread starter Thread starter Charlotte
  • Start date Start date
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?
 
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)
 
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.
 
Have you tried changing your Windows Regional Setting - that's where Excel
picks it default date format from
best wishes
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel should support the ISO standard date format 3
in an Excel table how do I set cell internal margins??? 6
converting data - re-formating data to "date" format 3
Create a bootable ISO image file from a bootable CD/DVD? 13
date formatting 1
Why can't I convert Long date format to Short date 1
Week Number 2
Convert European Date format to American Format 3

Back
Top