| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
decimal point position for less than 1 million
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| position of decimal point when entering a number ... | Excel Discussion (Misc queries) | |||
| Display a digit before or after the decimal point in another cell | Excel Worksheet Functions | |||
| format inplied decimal point | Excel Discussion (Misc queries) | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
| decimal point override does not work | Excel Discussion (Misc queries) | |||
Threaded Mode
