Need Help copying part of an Excel Cell?

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
 
S

Spencer101

Andrew said:
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!

Hi,

Try using:

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

And let us know how you get on.

S
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top