Can't think of way of formatting this - hopefully some other bright spark
will...

You could use a macro:

' -------------------
Sub DivideBy10()
Dim cel As Range
For Each cel In Selection
If cel.HasFormula = False Then
cel.Value = cel.Value / 10
End If
Next
End Sub
'-------------

although this would actually divide the values by 10.

HTH anyway...

"Ailish" wrote:

Hi All

I was wondering if you can create a custom format to divide by 10. As you
know you can create a custom format for 1000 i.e. 0, and 1m i.e. 0,,. I was
looking to do a similar style for this group of cells and I don't really want
to use the Paste Special and Divide or linking to another cell to divide.

Thanks
Ailish