Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Steve D
 
Posts: n/a
Default Automatically Convert values to $M

Good Morning,
I am wondering if there is a way to automatically convert my values to
$M I also want my scale to read $1M, $2M, $3M, etc.... Is there a way to do
this automatically?
--
Thank You,
Steve
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Automatically Convert values to $M

Similar to your other post, custom number format
#,,"M"

Cheers
Andy

Steve D wrote:
Good Morning,
I am wondering if there is a way to automatically convert my values to
$M I also want my scale to read $1M, $2M, $3M, etc.... Is there a way to do
this automatically?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Reply
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
Convert Data Range in to individual values mistryrg Excel Discussion (Misc queries) 2 June 7th 06 04:48 PM
Delete values from cell automatically ernie Excel Discussion (Misc queries) 5 February 15th 06 09:01 PM
How do I convert from text to columns automatically on import? byosko Excel Discussion (Misc queries) 1 November 16th 05 11:21 PM
how to automatically convert a number to words in Excel Anil-HML Excel Worksheet Functions 6 November 9th 05 03:04 AM
how can i automatically insert cell values into a comment field? spot987654321 Excel Discussion (Misc queries) 1 June 3rd 05 11:10 PM


All times are GMT +1. The time now is 09:43 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"