change first 2 digit ignore the other 2.
Another way...
put 300 in any blank cell
Copy that cell, then select your range, right click Paste Special, select
Add, OK
"Steved" wrote:
Hello from Steved
1010 to 1310 every second digit will change from 0 to 3
1030 to 1330
I would like a formula please to replace the 2 digit only as show'n above
ie 1010 to 1310 not 1010 to 1313
Thankyou.
|