ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   What's meaning of the Number Format? (https://www.excelbanter.com/excel-programming/409639-whats-meaning-number-format.html)

xiao

What's meaning of the Number Format?
 
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!


All times are GMT +1. The time now is 05:35 AM.

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