Thread: [Solved] Need a formula to copy cell data with its format
View Single Post
 
Old 04-23-2016, 07:08 AM
jeffreybrown jeffreybrown is offline Windows Vista 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