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.

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.

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.

If your time value is on Sheet1 cell A1, then on Sheet2 cell A1 put...

=Sheet1!A1

...and format as time

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.

When you say copy, this makes me think VBA, but you talked about a formula from the beginning. Formulas don't copy, they just retrieve from whatever cell they are linked too.

Why not just apply the format to the entire column at once and be done with it?

Yes. That can be done but there was an assignment requirement to write a formula.

It would be nice if you said that up front.

Maybe you are looking for

=TEXT(value,format_text)

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.

Perhaps Copy - Paste special - All

__________________
Using O365 v2503 - 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

That's manual too.

But thats OK. Really appreciate your help. Thanks you so much.

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.

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. 😆