Works for me. Perhaps you've got spaces or other invisible characters in
your cell? Have a look at =MID(A15,2,1) to see whether it finds zero. You
say it's not functioning, but you haven't told us what the formula returns.
--
David Biddulph

"Steved" wrote in message
...
Hello from Steved

Please what do I need to do to the below formula to change 4040 to 4140

At this time it is not functioning.

=IF(MID(A15,2,1)="0",A15+100,A15)

Thankyou.