You can format as % which times by a 100, but then you'll have a percentage
sign. Not sure that custom format lets you perform calculations on values.

You could do it using VBA, so when a value is entered into a cell its
multiplied by 100:

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = True
If Not Application.Intersect(Target, Range("A:A")) Is Nothing Then

Application.EnableEvents = False
Target = Target.Value * 100



End If

Application.EnableEvents = True


End Sub

If you press Alt + F11 it'll open the vb editor, then select the sheet you
want it to work on and copy and paste in the above code - you'll have to
alter the range to what you want, at the moment it's set to work only on
column A.



just a thought on how to get round it really...




"Tigerxxx" 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!