general formatting

[A Mad Doberman]

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!

 

[Bob Phillips]

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)