convert 10,300,000 to 10.3
 

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!

convert 10,300,000 to 10.3
 

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

If this post helps click Yes
---------------
Jacob Skaria


"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!

convert 10,300,000 to 10.3
 

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

convert 10,300,000 to 10.3
 

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.

"Jacob Skaria" wrote:

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

If this post helps click Yes
---------------
Jacob Skaria


"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!

convert 10,300,000 to 10.3
 

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

"Ron Rosenfeld" wrote:

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

convert 10,300,000 to 10.3
 

On Tue, 14 Apr 2009 06:13:01 -0700, Zor wrote:

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