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.