#1
|
|||
|
|||
Need a formula to copy cell data with its format
Can anyone help me to write a formula to copy cell data with its format? I am using MS Office 2007.
Any help would be greatly appreciated. Thanks in Advance. |
#2
|
|||
|
|||
You need to be much more specific than this.
What do you have now that your trying to copy? Where are you copying it too? What type of format are you referring too? The more specifics you give the better we can answer the question. |
#3
|
|||
|
|||
I am trying to copy cell values from one sheet to another. Its a time value in a particular format for ex. 1.30 PM.
The formula should copy data as well as its format in my first sheet. |
#4
|
|||
|
|||
If your time value is on Sheet1 cell A1, then on Sheet2 cell A1 put...
=Sheet1!A1 ...and format as time |
#5
|
|||
|
|||
Is there any way to copy time format from source to destination cell using formula?
I don't want to apply time format manually after data is copied. |
#6
|
|||
|
|||
Quote:
Why not just apply the format to the entire column at once and be done with it? |
#7
|
|||
|
|||
Yes. That can be done but there was an assignment requirement to write a formula.
|
#8
|
|||
|
|||
Quote:
Maybe you are looking for =TEXT(value,format_text) |
#9
|
|||
|
|||
Yes. Thats applying a particular format on the value. But to use =TEXT(value,format_text) I will have to provide a specific time format here (format_text). How would I know which specific format is used in source cell.
|
#10
|
||||
|
||||
Perhaps Copy - Paste special - All
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#11
|
|||
|
|||
That's manual too.
But thats OK. Really appreciate your help. Thanks you so much. |
#12
|
|||
|
|||
Not sure how you expect a formula to detect the formatting of another cell, but when you find your answers to the test, do let us know.
|
#13
|
|||
|
|||
Yes. There is no such formula exists in MS Excel yet. Will have to Convey this to the Microsoft technical team to create such new formula. 😆
|
Tags |
copy format |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
copy row into new sheet dependant on cell data | scorpain | Excel | 1 | 03-08-2016 02:37 PM |
copy a cell from 1 file to another when data changes | jpreeshl | Excel | 5 | 01-20-2016 09:06 AM |
Macro to copy formula from one cell to another | anwar | Excel Programming | 1 | 04-25-2014 08:27 PM |
Can I create a formula that will show result in the same cell and let me copy it down | CranstC | Excel | 1 | 02-11-2012 01:29 AM |
Use formula to copy cell formats also | mike_abc | Excel | 10 | 12-10-2011 01:55 AM |