Need a formula to copy cell data with its format

		Microsoft Office Forums > Microsoft Excel > Excel
Need a formula to copy cell data with its format

FAQ

Thread Tools

Display Modes

04-23-2016, 07:08 AM

jeffreybrown jeffreybrown is offline

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 about

Quote:

Originally Posted by wfhin2016

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?

Tags

copy format

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:28 PM.