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