Macro to Select Cells To Round 2 Decimals

[ext99k]

Hi everyone,

Thanks for taking the time to read my thread!

I was hoping that someone can please help me out. I tried to format cells to 2 decimals, but when I generate a tab delimited text file, the real cell values are shown, which have far too many decimals.

Would appreciate it if I can get some help to run a macro to select a range of cells and have them rounded to 2 decimal places.

Thanks so much!

 

[ext99k]

Found the answer!

Dim ThisCell As Range
For Each ThisCell In Range("A1:B5")
ThisCell.Value = Application.Round(ThisCell.Value, 2)
Next ThisCell