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:
Try using: =(A46 & " " & B46 & " " &TEXT(C46,"MM/DD/YY") And let us know how you get on. S. |
#3
|
|||
|
|||
Perfect! Works like a charm.
|
#4
|
|||
|
|||
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
Copying Part of a row down part of a column | Excel Discussion (Misc queries) |