Need Help copying part of an Excel Cell?
 

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 :)

Need Help copying part of an Excel Cell?
 

=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!