Start Cells with Specific Value

B

Beamers

I want a range of cells to automatically start with "E" and then I enter
other characters in the specific cells.

I also want a range of cells to automatically start with "10" and then enter
other numbers in the specific cells.

I know how to do that in Access but not in Excel.

Many thanks, in advance, for your help.
 
E

Elkar

If I understand you correctly, you want to be able to type, for example,
12345 into a cell, and have the cell automatically display E12345? If so:

Select your range of cells
From the Format Menu, select "Cells"
On the Number Tab, select "Custom"
Enter the Custom Format: "E"@
Or, for your other cells: "10"@
Click OK

Keep in mind, that while the cell will display E12345, the contents of the
cell are still 12345.

HTH,
Elkar
 
Top