Add specific text when something in typed into cell

Bendfella · Oct 28th 2020

Good day

i want when u type in a number and the number will always have 25364 (five numbers) the letters BD must appear before the numbers.

so when u type in 25364 in the cell it must show as BD25364

the cell range is on a specific worksheet and its from Column S6 to S28

is this possible even to use vba code in a module?

**royUK** · Oct 28th 2020

Use a Custom NumberFormat - "BD"00000

Select the cell or cells.
Right click and choose Format Cells.
Select Custom.
In the Type list, select an existing format, or type a new one in the box.
To add text to your number format: Type what you want in quotation marks. Add a space to separate the number and text.
Select OK.

Bendfella · Oct 28th 2020

thank you very much Roy, it worked.

You are our own excel guru

**royUK** · Oct 28th 2020

Pleased to help

Participate now!