Macro to remove decimal but leave number in brackets in place

[JohnGreen2]

Need a macro that will remove the .0 but to leave the bracket with number inside in place in Column Q2 -Q40(Range)

The data look like this
15.0(4)
10.0(3)
12.0(2)
6.0(2)
9.0(1)
22.0(1)
24.0(1)
21.0(1)
20.0(1)
18.0(1)
17.0(1)
14.0(1)
13.0(1)

I need it to look like this

15(4)
10(3)
12(2)
6(2)
9(1)
22(1)
24(1)
21(1)
20(1)
18(1)
17(1)
14(1)
13(1)

Rep given for a working one thanks for your help

[Fluff13]

How about

Please Login or Register  to view this content.

[maras_mak]

Hi, without a macro.

1. Select the range to remove '.0'
2. Press the Ctrl + H
3. In the Find what box type .0
4. Leave the Replace with box blank
5. Click the Replace All button.

Greetings.

[JohnGreen2]

How about

Please Login or Register  to view this content.

Thanks Fluff13 work like a charm +++Rep

[Fluff13]

You're welcome & thanks for the feedback