| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| international postal codes | Excel Worksheet Functions | |||
| International Yes or No | Excel Discussion (Misc queries) | |||
| International Excel 4 Macro | Excel Discussion (Misc queries) | |||
| International Equivalents | Excel Worksheet Functions | |||
| International number separator | Excel Worksheet Functions | |||
Linear Mode
