custom number format

[sareehy]

Hi,

Can i customize number format as the following:

If I type 1 it will display "ELC"
If I type 2 it will display "AC"
if i type 0 it will display "plm"

 

[Joe4]

Welcome to the Board!

Custom number formats usually break up the numbers into three categories, negative, positive, and zeroes. I do not know of a way you can do what you want for specific numbers using a Custom Number format.

I would probably opt for a lookup table, or VBA code do what you want (the VBA code can be created to run automatically upon manual cell updating).
If you are agreeable to a VBA solution, what range of cells would you want to apply this to?

 

[ISY]

Hi

[=1]"ELC";[=2]"AC";"plm";@

 

[Joe4]

Hi

[=1]"ELC";[=2]"AC";"plm";@

Did you try it?
It doesn't work for me. It returns the value I type into the cell and doesn't change anything.

 

[ISY]

HI

[=1]"ELC";[=2]"AC";"plm"

 

[Joe4]

HI

[=1]"ELC";[=2]"AC";"plm"

I honestly didn't know you could do this, so consider me educated.
That seems to work a little better, but still has issues.
If you enter anything other than 0,1, or 2, it will return "plm".

 

[ISY]

Hi

Alternatively by creating 4 rules, with conditional formatting