What is the purpose of putting #.## in a custom format?
For example: custom format 0,00 gives the same result as #.##0,00 , so why use #.##?
Hi Arti,
Welcome to our forum.
The # sign is a digit placeholder. Insignificant digits are not displayed by the #, whereas with the zero they are. e.g.
This format 00.00 applied to this number 1.50 will give you 01.50
Whereas this format ##.## applied to 1.50 will give you 1.5
More is explained in our Custom Number Format Guide.
Mynda
Thank you!
Hi Mynda,
Would like to add something to this question, For credit card , had 2 questions.
1. Used #### #### #### #### and it worked rather than the formula you used, would it be admissible to use this or there is something I'am missing ?
2. Why does the 16 th number also end as a zero? what if credit cards dont end with 0
A credit card should be entered as text, excel works only with numbers up to 15 digits, any digit after 15 digits will be replaced with 0.
Most likely you will not make calculations with a credit card number, so there is no need to enter it as a number.
See this article about floating point calculation.
Thank you Catalin
