.numberformat Q
not sure if this will help..
With Range("f42,h42,l42,q42")
If .NumberFormat = "0" Or .NumberFormat = "General" Then
.NumberFormat = "0.0"
Else
.NumberFormat = "### ##0.0"
End If
End With
--
If this is the answer you hoped for please remember to click the yes button
below...
Kind regards
Rik
"Aaron" wrote:
Hi,
I have a .numberformat code in place to change 123.12345 to 123.123 45
BUT
I am trying to get it to deal with the numbers before the decimal with
no luck.
With Range("f42,h42,l42,q42")
If .NumberFormat = "0" Or .NumberFormat = "General" Then
.NumberFormat = "0.0"
Else
.NumberFormat = .NumberFormat
.NumberFormat = Replace(.NumberFormat, "00000.0", "00 000.0")
End If
End With
TIA
Aaron.
.
|