In article , ?B?TWFya3VzIEZpc2NoZXI=?= wrote:
The simplest way would be to use the SUBSTITUTE function:

if your code is in cell D5 - "=SUBSTITUTE(D5,"-","-0")"

This is however quite simplistic, and will introduce a 0 even if there was
already one after the hyphen.

Please let me know if you want something more complex.

The various answers are fascinating ... and mine would be different again.
*Assuming* that the only place in your data that you have a - is where you
want the 0 inserted, select the data to work on and find '-' and replace
with '-0'. :)


"Mike" wrote:

how do I insert a zero ie 01535-1A to 01535-01A