What's meaning of the Number Format?

X

xiao

All,
I tried to get the number format of each cell. One example is that if I set
Date="*Wednesday, March 14, 2001" in the Format Cells Dialog, the number
format string I got is "[$-F800]dddd, mmmm dd, yyyy".
Anyone knows the meaning of "[$-F800]" in this format?

Also, I got "[$-409]d-mmm;@" in another date format.
What is the meaning of ""[$-409]"?
Thx!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top