View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lsaapedd lsaapedd is offline
external usenet poster
 
Posts: 3
Default How to format a number.

I have a column of numbers. Most have one decimal number, a few have none e.g.
370
370.0
370.1

Excel will NOT display the .0 in a number and I have not been able to figure
out how to force it. I only want a .0 to show if I actually type it. If a
number has no decimal number entered, I do NOT want one to display. If
anyone can help me with this I will be grateful.

Thanks.