In article , ?B?VGlnZXJ4eHg=?= wrote:
I did ask this question before, but did not get an answer.

How can I display 0.01 as 1 0r 10 or 100 i.e. how can I custom format
numbers to display them as higher numbers i.e. shift decimal to the right?

Would appreciate a solution a lot!

Well, the question here is, why would you want to ? Why not just put the
right number in and display it as it is ? Personally I have enough problems
with the 'percentage' format. Put in one number and it looks like another.
:)
Your question looks a bit like ...
... how can I display "Apple" as "Pear" ?

Any hints as to why you want to do this would be welcome ... and you might
get some answers. :)