| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can the "convert" function in excel convert to UK gallons? | Excel Discussion (Misc queries) | |||
| how will i convert 05.01.2007 convert 05.Jan.2007 format? | New Users to Excel | |||
| convert value in word. For Exampe Rs.115.00 convert into word as . | Excel Discussion (Misc queries) | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| Convert Time...!convert tenths of a second | Excel Discussion (Misc queries) | |||
Linear Mode
