using numeric formats in formulas


Posted by Marco on December 12, 2001 3:44 AM

Hi guys
I've got a little problem working with Exel 2K.
I've a number(format 000) in "A" column. in "B" column I've a constant "/02".
In "C" column I've a formula which concatenates column "A" with column "B".
Example:
A1 contains 006
B1 contains /02
C1 contains =A1&B1
This formula gives 6/02, but I need 006/02.
Is there any way to personalze numeric format inside the formula itself???

Thanks anyway and compliments for your great site.
Ciao, Marco.



Posted by Mike C on December 12, 2001 3:52 AM

=TEXT(A1,"000")&B1 (NT)