Hi Guys,

The reason I needed to do this is because when I display percentage values
in a bar chart for the individual bars, the % value is not diaplyed in one
line but displayed in 2 rows i.e. -24.3% will be displayed as "-24." above
and "3%" below it. This looks very unprofessional.
Hence I wanted to format these values to display as just -24.3 which then
puts all of them in one line.

Hope I was able to express the need. Thank you for your help!

"scp3030" wrote:

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!