Marklarbear
Board Regular
- Joined
- Nov 6, 2003
- Messages
- 113
- Office Version
- 365
- Platform
- Windows
Hi Brains Trust....
Hopefully this is a simple one - what would the VBA code be to change the first digit of a 3 digit number to change it to 5 ?
ie in the example below - in cell A2 it will change the number from 706 to 506, cell A6 from 880 to 580 and so on through to the bottom of the list.
cheers
Hopefully this is a simple one - what would the VBA code be to change the first digit of a 3 digit number to change it to 5 ?
ie in the example below - in cell A2 it will change the number from 706 to 506, cell A6 from 880 to 580 and so on through to the bottom of the list.
cheers