How do I format numbers in cells as follows: 12 as 12 123 as 1,23 1234 as 12,34 12345 as 123,45 I tried ##,## , but this formats 42343 as 42,343 instead of the desired 423,43 ####,## also not working.

Reputation: 351

Custom number format: comma preceding last two digits

How do I format numbers in cells as follows:

I tried ##,##, but this formats 42343 as 42,343 instead of the desired 423,43

####,## also not working.

Upvotes: 2

Reputation: 1

Go into Format>Cells>Custom and type in :

0","00

Upvotes: 0

Reputation: 38520

This custom format code works for the examples in your question:

[>=100]#\,#0;#

Upvotes: 2

Reputation: 526

Try: =IF(LEN(A1)<3,A1,REPLACE(A1,LEN(A1)-1,0,","))

Upvotes: 0