Thread
:
change first 2 digit ignore the other 2.
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Steved
external usenet poster
Posts: 519
change first 2 digit ignore the other 2.
Hello Don
Sorry I should have explained a liitle more clearly, yes only those with 0
Thankyou.
"Don Guillett" wrote:
All second characters to 3 or JUST those that are 0 (zero)???
--
Don Guillett
SalesAid Software
"Steved" wrote in message
...
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.
Reply With Quote
Steved
View Public Profile
Find all posts by Steved