How to repalce numbers after a decimal
One way:
=INT(A1)+0.95
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"dpscoupe" wrote in message
...
Lets say I have a column of numbers, that looks like this:
10.242
11.817
12.915
14.805
and I want it to look like this:
10.95
11.95
12.95
14.95
What function could be used to accomplish this?
|