sorry should be
=LEFT(A2,3)&$A$1&MID(A2,4,40)

"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