convert decimals to only 2 places

[TechRetard]

Good morning all- need help with a little macro

what i would like the macro to say is
1. set range to this (selected range)
2. check each cell in range
a. if cell is a decimal, it can only have max 2 #s after the decimal (hundreths), else move on

masks/formats won't work -- the actual number needs to be changed (i.e. x.xxxxx HAS to be x.xx)

Thanks in advance!!

[TechRetard]

combined some random code i found...best way?

Please Login or Register  to view this content.