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, 07:18 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

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