Add prefix to number

[sprinter1801]

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

[jj72uk]

Will it be the same prefix all the way through?

[JBeaucaire]

This is a way to add the prefix "XX" to the start of any numeric value typed anywhere in column A:

Please Login or Register  to view this content.

This is a sheet-level macro.

1) Right-click on the sheet tab
2) Select VIEW CODE
3) Paste in the code (given above)
4) Exit the VBEditor
5) Save your workbook as a macro-enabled workbook.

Now enter a numeric value in column A...

[jj72uk]

Reason why I was asking if it was to be the same prefix is becasue there are a few ways.

A macro is one.

Or you can format the cell using a custom format of XX #

Where XX is your prefix.

Or you can have an additioanl colum that sources where you type in and use ="XX " &A1

Again XX being the prefix and A1 being where you type your number in.

[Marcol]

Possibly
On the sheet you want to control

Please Login or Register  to view this content.

Add to the prefix array as required
Control the cells you want to prefix using "Intersect" function in the Select Case statement.

P.S.

Or you can format the cell using a custom format of XX #

Is only a display value and could be a problem if you need the prefix for further calcs

[Marcol]

Prompted by JB's post, and some sleep!

Please Login or Register  to view this content.

N.B.
The lines commented out (shown in green) can be uncommented if you need to prefix any string e.g. "Prefix_Test" would result from entering "_Test" in Range("D2:E10"))