Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Long Date Format
Greetings,
The windows long date format is: [$-F800]dddd, mmmm d, yyyy So, what does the "[$-F800]" do? I can't seem to figure it out. I'm using Excel 2007 SP1. Thanks, Shane. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Long Date Format
It is probably some international coding., representing the installation.
Does it matter? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Shane" wrote in message ... Greetings, The windows long date format is: [$-F800]dddd, mmmm d, yyyy So, what does the "[$-F800]" do? I can't seem to figure it out. I'm using Excel 2007 SP1. Thanks, Shane. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Long Date Format
It is the locale ID:
http://www.dailydoseofexcel.com/arch...-of-the-world/ -- Gary''s Student - gsnu200849 "Shane" wrote: Greetings, The windows long date format is: [$-F800]dddd, mmmm d, yyyy So, what does the "[$-F800]" do? I can't seem to figure it out. I'm using Excel 2007 SP1. Thanks, Shane. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Long Date Format
Thanks. A locale ID makes sense, but I can't find "[$-F800]" in the list of
locales from Microsoft. Any idea what "[$-F800]" is? Thanks, Shane. "Gary''s Student" wrote in message ... It is the locale ID: http://www.dailydoseofexcel.com/arch...-of-the-world/ -- Gary''s Student - gsnu200849 "Shane" wrote: Greetings, The windows long date format is: [$-F800]dddd, mmmm d, yyyy So, what does the "[$-F800]" do? I can't seem to figure it out. I'm using Excel 2007 SP1. Thanks, Shane. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Long Date Format
Does anybody know of any other newsgroups/forums I could try?
Thanks, Shane. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Long Date - Long Date = text is days | Excel Discussion (Misc queries) | |||
Does Excel have a cell format for lat/long in ° min sec format? | Excel Discussion (Misc queries) | |||
how long date difference | Excel Discussion (Misc queries) | |||
How do I use long date format in a header or footer? | Excel Discussion (Misc queries) | |||
Format single column cells to be 6 characters long | Excel Worksheet Functions |