you will have to do the typing in a differnt column and concatinate in the
"/". I am not sure from your example the variations , but from what I see
you can type in "000111-2222" in A2 have "'/" in A1 (make sure you have a
single tick then the /"
then in the cell you want say B2, have
=left(a2,3)&$a$1&mid(a2,3,40)

good luck


"Quietman" wrote:

Hello I Am Trying To Complete A Spreadsheet For Work And One Collum Is For
Invoice Numbers In The Following Format 000/111-2222. Letters sometimes apear
as well as numbers so is there a way of formatting the collum so that the /
and - do not need to be typed. Hope this makes sense.

QM