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