View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bagia Bagia is offline
external usenet poster
 
Posts: 46
Default Rounding value from millions to decimal places

Hello,

Is there a way to round a value that is currently displaying in millions to
a value with decimal places? Example, if my current value is 8,500,000 I
would like to now display it as 8.5 millions

Thank you