Financial number format

How can I change this function:

nFormat=NumberForm[#,{\[Infinity],2},NumberPoint->”,”,NumberSeparator->”.”,DigitBlock->3,ExponentStep->10]&;

So when I use it like:

nFormat/@{10.01,10.1,0.1}//Column

10,01

10,10

1.000.000.000,00*10^(-10)

The last number 1.000.000.000,00*10^(-10) get the format equals to 0.10?

=================

1

 

Setting ExponentStep to 2 gives a result You want, but I’m not sure if it is what You’re looking for
– Wojciech
Dec 3 ’13 at 15:12

=================

1 Answer
1

=================

See last paragraph in Scope:-

http://reference.wolfram.com/mathematica/ref/ExponentFunction.html

nFormat = NumberForm[#, {\[Infinity], 2},
NumberPoint -> “,”, NumberSeparator -> “.”, DigitBlock -> 3,
ExponentFunction -> (Null &)] &;

  

 

Excellent! It’s what I need. tks
– Murta
Dec 3 ’13 at 17:48