tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi everyone,
I have a range of B29:AZ32
I would like a macro the if a number is entered into and cell in this range that it makes it a negative
I.e if some put in 1.6 it changes it to -1.6
if they put in -1.6 it stays as it is
please help if you can
Thanks
Tony
I have a range of B29:AZ32
I would like a macro the if a number is entered into and cell in this range that it makes it a negative
I.e if some put in 1.6 it changes it to -1.6
if they put in -1.6 it stays as it is
please help if you can
Thanks
Tony