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.............. |
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.............. |
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.............. |
All times are GMT +1. The time now is 08:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com