Dear,
Thanks for your prompt action.
I succeeded with the following one recommended by Garys Student. Since I
am not even a novice in
VB codes I didnt try the codes of JE McGimpsey.
By the way, I tried not to round the value but couldnt succeed. Example:
1.524524 must be as 1.524.
Thanks a lot to you all,
John Britto
Sub CellEdit()
'
' CellEdit Macro
' Macro recorded 15-10-2005 by John Britto
'
Dim r As Range
For Each r In Selection
r.Value = "=" & Round(r.Value, 3) & "+0"
Next
End Sub
"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
Thanks for the attentino.
John Britto