Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-23-2016, 05:54 AM
wfhin2016 wfhin2016 is offline Need a formula to copy cell data with its format Windows 8 Need a formula to copy cell data with its format Office 2007
Novice
Need a formula to copy cell data with its format
 
Join Date: Apr 2016
Posts: 7
wfhin2016 is on a distinguished road
Question 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.
Reply With Quote
  #2  
Old 04-23-2016, 05:59 AM
jeffreybrown jeffreybrown is offline Need a formula to copy cell data with its format Windows Vista Need a formula to copy cell data with its format Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

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.
Reply With Quote
  #3  
Old 04-23-2016, 06:04 AM
wfhin2016 wfhin2016 is offline Need a formula to copy cell data with its format Windows 8 Need a formula to copy cell data with its format Office 2007
Novice
Need a formula to copy cell data with its format
 
Join Date: Apr 2016
Posts: 7
wfhin2016 is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 04-23-2016, 06:31 AM
jeffreybrown jeffreybrown is offline Need a formula to copy cell data with its format Windows Vista Need a formula to copy cell data with its format Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

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

=Sheet1!A1

...and format as time
Reply With Quote
  #5  
Old 04-23-2016, 07:01 AM
wfhin2016 wfhin2016 is offline Need a formula to copy cell data with its format Windows 8 Need a formula to copy cell data with its format Office 2007
Novice
Need a formula to copy cell data with its format
 
Join Date: Apr 2016
Posts: 7
wfhin2016 is on a distinguished road
Default

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.
Reply With Quote
  #6  
Old 04-23-2016, 07:08 AM
jeffreybrown jeffreybrown is offline Need a formula to copy cell data with its format Windows Vista Need a formula to copy cell data with its format Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Quote:
Originally Posted by wfhin2016 View Post
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?
Reply With Quote
  #7  
Old 04-23-2016, 07:11 AM
wfhin2016 wfhin2016 is offline Need a formula to copy cell data with its format Windows 8 Need a formula to copy cell data with its format Office 2007
Novice
Need a formula to copy cell data with its format
 
Join Date: Apr 2016
Posts: 7
wfhin2016 is on a distinguished road
Default

Yes. That can be done but there was an assignment requirement to write a formula.
Reply With Quote
  #8  
Old 04-23-2016, 07:18 AM
jeffreybrown jeffreybrown is offline Need a formula to copy cell data with its format Windows Vista Need a formula to copy cell data with its format Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Quote:
Originally Posted by wfhin2016 View Post
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)
Reply With Quote
  #9  
Old 04-23-2016, 07:35 AM
wfhin2016 wfhin2016 is offline Need a formula to copy cell data with its format Windows 8 Need a formula to copy cell data with its format Office 2007
Novice
Need a formula to copy cell data with its format
 
Join Date: Apr 2016
Posts: 7
wfhin2016 is on a distinguished road
Default

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.
Reply With Quote
  #10  
Old 04-23-2016, 07:42 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now Need a formula to copy cell data with its format Windows 7 64bit Need a formula to copy cell data with its format Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #11  
Old 04-23-2016, 07:53 AM
wfhin2016 wfhin2016 is offline Need a formula to copy cell data with its format Windows 8 Need a formula to copy cell data with its format Office 2007
Novice
Need a formula to copy cell data with its format
 
Join Date: Apr 2016
Posts: 7
wfhin2016 is on a distinguished road
Default

That's manual too.

But thats OK. Really appreciate your help. Thanks you so much.
Reply With Quote
  #12  
Old 04-23-2016, 07:56 AM
jeffreybrown jeffreybrown is offline Need a formula to copy cell data with its format Windows Vista Need a formula to copy cell data with its format Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

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.
Reply With Quote
  #13  
Old 04-23-2016, 08:13 AM
wfhin2016 wfhin2016 is offline Need a formula to copy cell data with its format Windows 8 Need a formula to copy cell data with its format Office 2007
Novice
Need a formula to copy cell data with its format
 
Join Date: Apr 2016
Posts: 7
wfhin2016 is on a distinguished road
Default

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. 😆
Reply With Quote
Reply

Tags
copy format

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need a formula to copy cell data with its format copy row into new sheet dependant on cell data scorpain Excel 1 03-08-2016 02:37 PM
Need a formula to copy cell data with its format 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
Need a formula to copy cell data with its format Use formula to copy cell formats also mike_abc Excel 10 12-10-2011 01:55 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:53 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft