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

There are probably easier ways but you could use a concatenate formula e.g.
if the "01535-1A is in cell A1 then use:
=CONCATENATE(LEFT(A1,6),0,RIGHT(A1,2))

"Mike" wrote:

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

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.

Markus

"Mike" wrote:

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

Click on the cell that contains 01535-1A, hit F2 (this will let you edit
inside the cell) and type in the 0.

"Mike" wrote:

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

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