LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
ash ash is offline
external usenet poster
 
Posts: 54
Default Converting #s to specified #digits

Hi! Any help is appreciated.

I have two columns of data that represent dollar amounts. The amounts vary
across the board. Is there a formula that I could put in that would take the
numbers and change them all to be represented in a single dollar amount?

For example, if I want to represent everything in millions (Mk),
7,240,000 would be displayed as 7.2; 125,000 would be displayed as .1

I would also like to make sure it is rounding the tenths places, so that if
the first example had been 7,280,000, it would display as 7.3

If there's not a formula that can do this, could you also let me know.
Thanks!
 
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
last ten digits Martina Excel Worksheet Functions 5 December 1st 06 04:53 AM
16 digits Jane Excel Discussion (Misc queries) 10 January 20th 06 11:51 AM
Converting Dates to 8 digits jermsalerms Excel Worksheet Functions 17 January 20th 06 02:00 AM
2 DIGITS OUT OF 4 gregork Excel Discussion (Misc queries) 9 February 20th 05 03:30 PM
2 DIGITS OUT OF 4 Knoxi Excel Discussion (Misc queries) 0 February 19th 05 05:54 PM


All times are GMT +1. The time now is 01:22 PM.

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"