Custom formatting to force a decimal place

M

Mike K

Oh wise ones,
I have some custom cell formatting that prefixes some
text to a value. I would like to force 1 decimal place even if it is zero.
Currently if it is zero it just displays the whole number. Any suggestions?

custom format is "LFE Scan="###.# "LBS"

Thanks,
Mike
 
Top