Search code examples
excelexcel-2007

Custom number format: comma preceding last two digits


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.


Solution

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

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