how to round figures?

  • Thread starter Thread starter Efren Llarinas
  • Start date Start date
E

Efren Llarinas

I have a spreadsheet in whole figures which I wish to convert into thousands
(like 10,500 should convert to 10.5) after I highlight the figure and click a
certain format or formula.
 
Hi,

Try the following custom format:

#.#,

Format, Cells, Number tab, Custom, and enter the above on the Type line.
 
I think I would use this...

0.0,

instead to protect against a value like 1000 showing with a dot at the end
of it or 10 showing as just a dot by itself.
 
Back
Top