ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Need Help copying part of an Excel Cell (https://www.excelbanter.com/excel-worksheet-functions/446195-need-help-copying-part-excel-cell.html)

Andrew Arce
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!

Spencer101
Quote:
Originally Posted by Andrew Arce (Post 1602230)
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,

See the reply in your duplicate post
http://www.excelbanter.com/showthread.php?t=446194


All times are GMT +1. The time now is 10:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com