View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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!