Hello All

Can Any 1 tell me how to do the following

I want to type a number into a cell and then auto add a prefix letter to it.

I can't use the cell format route as I am using the sumif latter in the sheet and it wont work with a formatted cell

Any Help ?

Thanks