A
Andrew Arce
Hi,
I'm working on an excel sheet and need some help copying the format fro
one excel cell into another. In the main cell, i have; =(A46 & " " & B4
& " " &C46). Everything works okay, but the cell in C46 is originally
date (11/24/10). When I use the formula above, the date gets turned int
a number. Does anyone know how I can get that part of the cell to no
automatically turn into a number? I already tried format paste an
changing the format of the cell.
Any other ways anyone can recommend?
Thanks
I'm working on an excel sheet and need some help copying the format fro
one excel cell into another. In the main cell, i have; =(A46 & " " & B4
& " " &C46). Everything works okay, but the cell in C46 is originally
date (11/24/10). When I use the formula above, the date gets turned int
a number. Does anyone know how I can get that part of the cell to no
automatically turn into a number? I already tried format paste an
changing the format of the cell.
Any other ways anyone can recommend?
Thanks