convert 10,300,000 to 10.3

[Zor]

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!

 

[Jacob Skaria]

A1 = 10300000
=TEXT(A1/1000000,"00.0")

If this post helps click Yes

 

[Ron Rosenfeld]

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

 

[Zor]

Thanks, Jacob! Can I do this if each of the cells are a different number? I
have a full spreadsheet of about 15 columns and 40 rows I need to convert.

 

[Zor]

Brilliant! Thank you! It was the former way and now it shows as 10.3.
Appreciate the help!

 

[Ron Rosenfeld]

Brilliant! Thank you! It was the former way and now it shows as 10.3.
Appreciate the help!

Glad to help. Thanks for the feedback.
--ron