ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Long Date Format (https://www.excelbanter.com/excel-worksheet-functions/228957-long-date-format.html)

Shane

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.


Bob Phillips

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.





Gary''s Student

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.



Shane

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.



Shane

Long Date Format
 
Does anybody know of any other newsgroups/forums I could try?

Thanks,
Shane.


All times are GMT +1. The time now is 03:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com