Date custom formats

[Guest]

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

 

[David Biddulph]

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/archives/2006/02/27/months-of-the-world/

 

[Guest]

Thank you David - I've learned something new!

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/archives/2006/02/27/months-of-the-world/