Hi,

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

Any other ways anyone can recommend?

Thanks!

Hi,

Try using:

=(A46 & " " & B46 & " " &TEXT(C46,"MM/DD/YY")

And let us know how you get on.

S.

Perfect! Works like a charm.

Glad to hear it :)

=A46 & " " & B46 & TEXT(C46," mm/dd/yyyy")


Gord

On Wed, 30 May 2012 14:49:08 +0000, Andrew Arce
wrote:


Hi,

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

Any other ways anyone can recommend?

Thanks!