I'm trying to find if there is a way to do a specific type of number formating in Calc, what I'll call 'scaled' formating.
If I'm using numbers like 1,000,000,000 (one billion), 2,000,000,000 (two billion), etc. and I want them to display on a graph axis as 1.0 B, 2.0 B, etc. is there a format I can apply to the graph axis to make the numbers display like that? If yes, what is the format code? If there's not a format to apply to the axis is there a format that can be applied to the cells to make the numbers display that way. Again, if there is what is that format? (I would use the chart feature that says "use source formating" in this case.) Thank you. -ab
