LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Format numerical value to Million

Hi,
I try to format a numerical value in Million. But I don't want to use
the number to divide by 1,000,000. Is there any way which I can just
use a format function? (i.e.: 12,666,678 ---- 12,7)
Your help is greatly appreciated! Thanks in advance!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change column format? numerical not alphabetical ISco Excel Discussion (Misc queries) 3 December 12th 07 07:35 PM
Replace million-billion number format to lakhs-crores format Sumit Excel Discussion (Misc queries) 1 December 9th 05 04:58 PM
format degrees, mg/l, parts per million dumbfounded Excel Discussion (Misc queries) 2 February 1st 05 02:47 AM
Can I set the numerical type of Cell to Hex format hon123456 Excel Discussion (Misc queries) 2 January 13th 05 01:01 PM
MS Excel should allow you to format numerical values to thousand. Elias Nunez Excel Worksheet Functions 1 December 2nd 04 04:06 PM


All times are GMT +1. The time now is 05:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"