Thread
:
Add decimal to number
View Single Post
#
4
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Add decimal to number
One way
Sub dodigits()
For i = 1 To 6
Cells(i, "b") = Cells(i, "b") / 100
Cells(i, "b").NumberFormat = "0.000"
Next i
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"evoxfan" wrote in message
...
I have a column of 5 digit numbers like this:
15055
15060
15071
I would like add a decimal after 3 digits and 0 to the end to show:
150.550
150.600
150.710
What would be the best way to accomplish this?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett