Brooks W.

Posts: n/a

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 12:01 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us