Formula Question ??
Posted by Herman on May 02, 2001 9:49 PM
I have three cells a1 a2 and a3
in these cells i have numbers with the format 00
so when i type in 2 in the cell stands 02
typed in a1 2 looks in the cell as 02
a2 3 03
a3 1 01
now i want to display in cell a4 the result of combining the cells a1 a2 and a3
so there should be 020301 in cell a4 but i get 231
how can i fix this problem it seems that what is visible on my screen is not what is being combined together.