Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date custom formats
XL2003. I've checked Help and this forum, but I am still wondering what these
notes like [$-F800] in front of date custom formats mean? I understand the other bits but these bits dont seem to do anything. [$-809]dd mmmm yyyy and [$-F800]dddd, mmmm dd, yyyy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date custom formats
"Jonathan" wrote in message
... XL2003. I've checked Help and this forum, but I am still wondering what these notes like [$-F800] in front of date custom formats mean? I understand the other bits but these bits don't seem to do anything. [$-809]dd mmmm yyyy and [$-F800]dddd, mmmm dd, yyyy http://www.dailydoseofexcel.com/arch...-of-the-world/ -- David Biddulph |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date custom formats
Thank you David - I've learned something new!
"David Biddulph" wrote: "Jonathan" wrote in message ... XL2003. I've checked Help and this forum, but I am still wondering what these notes like [$-F800] in front of date custom formats mean? I understand the other bits but these bits don't seem to do anything. [$-809]dd mmmm yyyy and [$-F800]dddd, mmmm dd, yyyy http://www.dailydoseofexcel.com/arch...-of-the-world/ -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Imported Date Formats | Excel Worksheet Functions | |||
New custom % formats are only in XL file they are set up in. WHY? | Excel Worksheet Functions | |||
Date Formats | Excel Discussion (Misc queries) | |||
troubleshooting date formats | Excel Discussion (Misc queries) | |||
How do I make custom formats with superscript or subscript%3f | Excel Worksheet Functions |