Thread: decimal point position for less than 1 million
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Muhammed Rafeek M Muhammed Rafeek M is offline
external usenet poster
  
Posts: 179
Default decimal point position for less than 1 million
Hi
I can help you. Please send me that file to i will reply
you.
Thanks and regards
Muhammed Rafeek M

"BethG" wrote:


I have a chart based on a worksheet with values both above and below
1,000,000. The chart labels show values above 1 million correctly
(e.g., 2,500,000 is represented as 2.5 M) but for values under 1
million, it puts the decimal point after the "M" rather than befor the
number (e.g., 520,000 should be represented as .52 M, but instead looks
like "52M."

Anyone know how to correct this?

Thanks!


--
BethG
------------------------------------------------------------------------
BethG's Profile: http://www.excelforum.com/member.php...o&userid=36510
View this thread: http://www.excelforum.com/showthread...hreadid=562689


Reply With QuoteReply With Quote