LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Hiding numbers in a Text cell.

I'm not completely familiar with all of the possible function of excel and
use both 2003 and 2007.

I want to make a column which shows text but has hidden numerical values
assigned to them.

Example: In C2 I have "Matched Point" and it has a value of "40". In C3 I
have "Basic Fun" which has a value of "25".

Each text and value needs to be different but I don't want to have to "Hide"
a column of values. Can this be done?

Thanks for any possibilities! :)
Fallton


 
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
how to extract numbers from imported cell with text and numbers? jyin Excel Discussion (Misc queries) 3 March 28th 07 01:14 PM
copy numbers from numbers+text cell Henk Excel Worksheet Functions 3 August 11th 06 02:48 PM
Extract numbers from cell with Text and Numbers wiredwrx New Users to Excel 3 April 18th 06 10:57 PM
extract numbers from cell containing text & numbers [email protected] Excel Worksheet Functions 1 November 14th 05 07:04 AM
How do I view cell text without it visually hiding other cells? ldmci Excel Discussion (Misc queries) 1 May 27th 05 04:12 PM


All times are GMT +1. The time now is 10:36 AM.

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"