No real way to build logic into a number format in excel.

in a number format you tell it what you want a positive number to look like,
a negative number, zero and text.


"barryderay" wrote:

I want a custom type that will take '5W' and put a zero in front, making it
'05W'. I used the 00 custom type and it would turn 5 into 05. I got a reply
to an earlier post suggesting to use "0"@. This worked but I forgot to
mention that if 05W or 15W was entered I want it left alone. "0"@ added the
zero to the beginning turning it into 005W or 015W.