very simple question about format cell

[LearnMeExcel]

hi all
when i format my cell i am using
Number
Decimal Places = 3
and Check Use 1000 Separator
after that
when i check Custom i found this code
#,##0.00

My question
why Excel add two hash # not one
i get the same result with
#,#0.00

Sorry For ask this simple question

 

[Sektor]

The difference is that # can appear or not when 0 is always present.

 

[Andrew Poulsom]

The # signs are placeholders. You can't have the number format #,#0.00. If you enter that in the Type box and click OK Excel will convert it to #,##0.00 (when you look at the Format Cells dialog again).

 

[LearnMeExcel]

The difference is that # can appear or not when 0 is always present.

Sorry could you give me example for it

 

[Andrew Poulsom]

Sorry could you give me example for it

Read Excel Help on Number format codes and the subtopic Decimal places and significant digits.

 

[LearnMeExcel]

The # signs are placeholders. You can't have the number format #,#0.00. If you enter that in the Type box and click OK Excel will convert it to #,##0.00 (when you look at the Format Cells dialog again).

Yes andrew it is come back to
#,##0.000

thank you
another question please andrew
i found some strange code in format cell like
[$-1000000]0 to display number in english
or [$-10B000] to convert date

where i can found full dictionary for this codes

 

[pgc01]

Hi

Read here:

http://office.microsoft.com/en-us/excel-help/creating-international-number-formats-HA001034635.aspx

 

[LearnMeExcel]

Hi

Read here:

http://office.microsoft.com/en-us/excel-help/creating-international-number-formats-HA001034635.aspx

Really Thanx pgc01
it is amazing Link
that is what i am looking for