View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default general formatting

409 is the international code, for formatting option, US here.

mmmm gives you the long month name as against mm's 2 digit month number.

The @ is general format for negative numbers, but as this is a date, it
shouldn't be negative.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"A Mad Doberman" wrote in message
...
I wish to know more about formatting code. For example, by recording a
macro, I can tell that the code below forces a date to appear a
certain way.

"[$-409]mmmm d, yyyy;@"

By recording, copying, and pasting I am usually able get things to
look the way I want. However, I would like to understand this type of
code a little better.

What does the [$-409} do?
What does mmmm do as opposed to mm, or d as oppossed to dd?
What does ;@ mean?

The above questions are meant to be rhetorical. I would rather know
how to learn this information for myself, since the above code is
merely one example.

Thanks all!