That's not what the OP wrote that he wanted.
With 1520.12565415 in a selected cell, this macro will result in a string
1520.126+0
when the OP's specification was
=1520.125+0
In article ,
Gary''s Student wrote:
select your cells and run:
Sub Macro1()
Dim r As Range
For Each r In Selection
r.Value = Round(r.Value, 4) & "+0"
Next
End Sub
--
Gary''s Student
"John Britto" wrote:
I shall be thankful if any one helps me to create a macro or so..to solve
the
following:
I have hunderes of cells with 8 digits decimals. When I click a maco the
cell to be updated as:
Presnt date: 1520.12565415
Desired Result: =1520.125+0
|