Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Display definition of a value in cell: 1 = F/T, 2 = P/T, etc
I have a worksheet with imported data. I want to display the verbal
description for the numeric value in a field. Ex: 1 = F/T, 2 = P/T I would rather see F/T in the field instead of 1. I hope this makes some sense.............. |
#2
|
|||
|
|||
Display definition of a value in cell: 1 = F/T, 2 = P/T, etc
Hi Mike
If your numbers are in column A, then put this formula in column B: =IF(A1=1,"F/T",IF(A1=2,"P/T","")) Did you only have two different entries (F/T & P/T) ?? Cheers, -- Kevin Lehrbass www.spreadsheetsolutions4u.com "mike" wrote: I have a worksheet with imported data. I want to display the verbal description for the numeric value in a field. Ex: 1 = F/T, 2 = P/T I would rather see F/T in the field instead of 1. I hope this makes some sense.............. |
#3
|
|||
|
|||
Display definition of a value in cell: 1 = F/T, 2 = P/T, etc
you can use a custom format like
[=1]"F/T";[=2]"P/T" this will display F/T instead of 1, P/T isntead of 2, all other numbers are displayed normally. The cell value won't change, only the output of the cell. Or you can do a find and replace to actually replace the 1's with F/T and 2's with P/T. If these aren't what you want please explain differently, and I will try and help you more. "mike" wrote: I have a worksheet with imported data. I want to display the verbal description for the numeric value in a field. Ex: 1 = F/T, 2 = P/T I would rather see F/T in the field instead of 1. I hope this makes some sense.............. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display contents of a specific cell even if a group of cells is mo | Excel Worksheet Functions | |||
Display a row if a cell value is greater than zero | Excel Worksheet Functions | |||
How do I display hyperlink in Excel cell? | Excel Discussion (Misc queries) | |||
display the value of a cell adjacent to the cell with max value | Excel Worksheet Functions | |||
How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel |