Number formatting in 100,000s

[mayaicar]

I wish to present my data in hundreds of thousands (i.e. 150,000 would show as 1.5). I currently know how to display the custom format in thousands and millions, so I'm not looking for this. I wish to know which custom format/number format would display my numbers in 100,000s. Any help with this would be much appreciated ?

 

[jasonb75]

With formatting you can only do it with thousands or millions, other units would need the value to be adjusted (by formula or vba) to show the desired result.

 

[mayaicar]

With formatting you can only do it with thousands or millions, other units would need the value to be adjusted (by formula or vba) to show the desired result.

Thanks, Jason!