Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Start Cells with Specific Value
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Start Cells with Specific Value
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 "Beamers" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format page number in excel footer to start at a specific page # | Excel Discussion (Misc queries) | |||
How to start Excel on a specific Worksheet. | Excel Discussion (Misc queries) | |||
use Now() in two cells for start and finish times | Excel Worksheet Functions | |||
check if the text string start with a specific character | New Users to Excel | |||
Empty cells at start of x axis | Charts and Charting in Excel |