custom number format cells based on text

[livermore]

Hi.

Is it possible to custom number format a cell based on text?

For example, I have a column with a bunch of people names.
What I want is based on the name written, the cell will only allow a 2 digits number or a 4 digit number.

I tried something like =TEXT(A1;"VLOOKUP(C1;$D$1:$E$10;2)"), but I had no luck.

I thought using the VLOOKUP so I could use the format "0.00" and "0.0000" for each person name, so the text function would recognize the format, but apparently I was wrong.

Any help?

Regards.

 

[jimrward]

with a number 12 in a1, and '0000 in A2 preceded by a single quote to make it a string then

=text(A1,A2) gives 0012, so appears to work for me, maybe you need to remove the double quotes around the VLOOKUP

 

[livermore]

Hi.

Maybe TEXT is not the right function to do what I want

Another example:
In A1 I have written Peter and in A2 I have written John.
When I write in B1, I want that cell to be able to recognize Peter's name and know that in that cell, can only be written 2 digit numbers, for example, 33.26. If I write 2.3254 the cell only will accept 2.32.
In B2, that cell must recognize John's name and know that in that cell can only be written 4 digit numbers, for example, 6.3214. If I write 1.23, the cell will add 2 zeros to the number so it can have the 4 digits.

This is what I wanted to do.
I cannot transform the number into text since I need them to do some calculations.

Is it possible?

Regards