On Tue, 14 Apr 2009 05:32:05 -0700, Zor wrote:

Hello,

I have a spreadsheet full of numbers and need to convert to decimal. Is
there an easy way? For example, convert 10,300,000 to 10.3 using a format
function.

Thank you!

It's not clear to me what you mean by "convert to decimal" or "convert ...
using a format function"

Do you want the contents of the cell to remain as 10,300,000 but merely be
displayed as 10.3?

Or do you want the contents of the cell to change to 10.3?

If the former, you can use the custom format
Format/Cells/Number/Custom Type: #0.0,,

If the latter, enter 1,000,000 in some cell. Then
Edit/Copy
Select your range of cells to be converted
Edit/Paste Special Divide

Then format as Number with one decimal place.
--ron