Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help in formating cells
I'm running into a brain buster for my simple mind. I want to be able to put an number into a cell, but have a word show instead. Is this possible? For example: in Cell A1, I will type "000053", but would like "Frontier" to show. Any help will be greatly appreciated, for this might show my CEO that I might know something they don't! -- ExcelNubee ------------------------------------------------------------------------ ExcelNubee's Profile: http://www.excelforum.com/member.php...o&userid=32719 View this thread: http://www.excelforum.com/showthread...hreadid=525547 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help in formating cells
Make a table with the numbers in one column then another column with what
the numbers represent put them somewhere of the visible area, in for instance numbers in Y1:Y50 and text in Z1:Z50 then use =IF(A1="","",VLOOKUP(A1,Y1:Z50,2,0)) if you put that formula in C2 then type the number in A1 note that leading zeros does not matter if the numbers are really numbers, however if you format Y1:Y50 and A1 as text you can use leading zeros and they will have an impact -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "ExcelNubee" wrote in message ... I'm running into a brain buster for my simple mind. I want to be able to put an number into a cell, but have a word show instead. Is this possible? For example: in Cell A1, I will type "000053", but would like "Frontier" to show. Any help will be greatly appreciated, for this might show my CEO that I might know something they don't! -- ExcelNubee ------------------------------------------------------------------------ ExcelNubee's Profile: http://www.excelforum.com/member.php...o&userid=32719 View this thread: http://www.excelforum.com/showthread...hreadid=525547 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formating Worksheet Cells | Excel Discussion (Misc queries) | |||
Formating Cells | Excel Discussion (Misc queries) | |||
Formating text in cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |