Microsoft Office Forums - View Single Post - [Solved] Need a formula to copy cell data with its format

Thread: [Solved] Need a formula to copy cell data with its format

View Single Post

Old

04-23-2016, 06:31 AM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown 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