Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Brooks W.
 
Posts: n/a
Default Change Text to a number

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   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert numbers from text format to number format merlin68 Excel Discussion (Misc queries) 7 June 20th 07 07:03 PM
Using Excel converts number to english text Lionel Lim (Malaysia) Excel Worksheet Functions 1 April 22nd 05 10:16 PM
How can I asign a number value to a text line in Excel? AIF_GoofyDo2 Charts and Charting in Excel 0 December 6th 04 01:19 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
Change number of columns mid page? Bluemax Excel Worksheet Functions 4 November 24th 04 02:11 AM


All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"