I'm reading your comment as replacing a "." with a ".", hence I don't
understand how that helps...I've done what you have mentioned, but I
have the original results.

On Feb 1, 11:27*am, Dave Peterson wrote:
Try formatting the range as General
Then edit|replace
what: *. *(decimal point)
with: *.
replace all

Record a macro when you do it in code and you should be ok.





S Himmelrich wrote:

Basically, I've tried to format the cell in a macro and as it's a
string it's not reformatting so this is the case I'm trying to
resolve . . .

My original data looks like this:

151.00
1.00
2.25
16.00
16.20

I'm looking for a result like this""
151
1
2.25
16
16.2

--

Dave Peterson- Hide quoted text -

- Show quoted text -