Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Quote:
See the reply in your duplicate post https://www.excelbanter.com/excel-discussion-misc-queries/446194-need-help-copying-part-excel-cell.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Help copying part of an Excel Cell? | Excel Discussion (Misc queries) | |||
Copying part of a cell | Excel Discussion (Misc queries) | |||
Copying Chuns - A part of the whole Field - from Access to Excel | Excel Programming | |||
Copying part of a string to another cell | Excel Programming | |||
Copying part of a cell | Excel Discussion (Misc queries) |