Number Format using hash keys - Logic

[chriys1337]

HI,

I have a question regarding the Number Formatting:

Num( 35648, '#,##0.##')

Why are there hash keys used, just not one digit before the decimal place.

I want to understand the logic behind this, can anybody please help?

[JordyWegman · Accepted solution]

Hi Chriys,

See this explanation:

Format	Name	Description	Examples
"0"	Zero placeholder	Replaces the zero with the corresponding digit if one is present; otherwise, zero appears in the result string.	1234.5678 ("00000") -> 01235 0.45678 ("0.00", en-US) -> 0.46 0.45678 ("0.00", fr-FR) -> 0,46
"#"	Digit placeholder	Replaces the "#" symbol with the corresponding digit if one is present; otherwise, no digit appears in the result string. Note that no digit appears in the result string if the corresponding digit in the input string is a non-significant 0. For example, 0003 ("####") -> 3.	1234.5678 ("#####") -> 1235 0.45678 ("#.##", en-US) -> .46 0.45678 ("#.##", fr-FR) -> ,46

Jordy

Climber

[chriys1337]

Thank you, that explains it :).