how to interpret this number formats

[lezawang]

Hi
I just want to undestand how to read these 2 numbers formats and I think that would help me to understand the reset. I have struggled to understand these 2? why # and 0, and why 0.00 (the dot). and why both # and 0 in the same format? Would appreciate any hint

1) #,##0.00
2) #,##0

 

[footoo]

Have a look at "Changing Decimal Places, Significant Digits, and Commas" here :
http://www.exceltactics.com/definitive-guide-custom-number-formats-excel/

 

[Rick Rothstein]

Hi
I just want to undestand how to read these 2 numbers formats and I think that would help me to understand the reset. I have struggled to understand these 2? why # and 0, and why 0.00 (the dot). and why both # and 0 in the same format? Would appreciate any hint

1) #,##0.00
2) #,##0

These formats are how you display a number with thousands separator (for example, 1,234.56 instead of 1234.56). The # signs are place keepers for digits that display nothing if there is no digit to fill that location whereas 0 displays a zero when there is no digit to fill that location.

 

[lezawang]

Thanks all for help and reply. I tried this format #,##0.00
I do not understand why "##" after the comma so I said I will try create a new format #,0.00 to my surprised, I got the same result
So why i need #,##0.00 when I can make it #,0.00
Thanks once again

 

[Rick Rothstein]

Thanks all for help and reply. I tried this format #,##0.00
I do not understand why "##" after the comma so I said I will try create a new format #,0.00 to my surprised, I got the same result
So why i need #,##0.00 when I can make it #,0.00

If you go back and look at the Custom Format again, you will see the VBA has expanded it from the #,0.00 you typed in to the standard #,##0.00 format automatically.