Format Number (custom)
 

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 but I haven't
found a working solution for the integer and character combination.

"0"@


"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 but I haven't
found a working solution for the integer and character combination.

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.

barryderay,

A custom format of 0?W works for me in XL97

HTH

Sandy

--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"barryderay" wrote in message
...

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.