Userdefined number format in excel shows just hashes

I have a few cells with numbers:

I gave them the number format #.##0 "Mio. Liter". So, for example the number 8145369 becomes 8.145.369 Mio. Liter:

However, the cells just show Hashes:

When I hover a cell, the correct format (8.145.369 Mio. Liter) is shown in the hover info.

How can I show the numbers correctly formatted?

>Solution :

You just need to make the column wider. A column containing a number must be wide enough for it to display its formatted value or you will see hash marks (unlike with text).