Fixed Character Count (custom format for Numbers)

Gurus, I would appreciate your help with this challenge. For some reason, the requirement calls for rows of numbers that have fixed number of characters, discounting decimal points. For example, if I type 23.5 in a cell and the requirement calls for 4-digit characters only, the cell would return 23.50 (4 characters excluding the decimal point). Next if I type 523.596, the cell would return 523.6 (again 4 characters excluding decimal point). For more examples, allow me to illustrate (see attached image).

table.jpg

I tried the Custom format for Numbers by using 0000 in Format Cells (CTRL+1) but it yields output not the one I need. Thanks in advance!

Originally Posted by pike

hello,
you can use conditional formatting in the cells to set the number formatting based on the cell value

that is great solution

Combining the suggestions/solutions presented by @pike and @JBeaucaire, I was able to achieve the desired output. It works perfectly the way I want it. Thank you very much, gentlemen!!