how to round figures?
 

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.

how to round figures?
 

Hi,

Try the following custom format:

#.#,

Format, Cells, Number tab, Custom, and enter the above on the Type line.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Efren Llarinas" wrote:

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.

how to round figures?
 

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.

--
Rick (MVP - Excel)


"Shane Devenshire" wrote in
message ...
Hi,

Try the following custom format:

#.#,

Format, Cells, Number tab, Custom, and enter the above on the Type line.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Efren Llarinas" wrote:

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.