Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I am trying to see if there is a way to change text entered into a cell into
a number based on the text entered. As an example, an airport code of MSP would need to be changed to a store number 510. Is there a way to do this in Excel 2000? There are about 25 codes that could be entered and of course 25 numbers. Any suggestions would be appreciated. -- Brooks W. |
#2
![]() |
|||
|
|||
![]()
There's a sample workbook on my web site that shows a product name and
code in the Data Validation dropdown list. After an item is selected, the cell shows only the product name. You may be able to adapt this to your workbook. On the following page: http://www.contextures.com/excelfiles.html Under the data validation heading, look for 'Data Validation "Columns" Brooks W. wrote: I am trying to see if there is a way to change text entered into a cell into a number based on the text entered. As an example, an airport code of MSP would need to be changed to a store number 510. Is there a way to do this in Excel 2000? There are about 25 codes that could be entered and of course 25 numbers. Any suggestions would be appreciated. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
Using Excel converts number to english text | Excel Worksheet Functions | |||
How can I asign a number value to a text line in Excel? | Charts and Charting in Excel | |||
GET.CELL | Excel Worksheet Functions | |||
Change number of columns mid page? | Excel Worksheet Functions |