Microsoft Office Forums - View Single Post - Convert Formula Result to Static Text

Thread: Convert Formula Result to Static Text

View Single Post

Old

01-19-2013, 07:04 AM

brainstewn brainstewn is offline

brainstewn is offline

brainstewn uses Windows 7 64bit

Windows 7 64bit brainstewn uses Office 2010 32bit

brainstewn uses Office 2010 32bit

Office 2010 32bit

Novice

Join Date: Jan 2013

Location: Utah

Posts: 1

brainstewn is on a distinguished road

Default

Convert Formula resulting in a DATE to static text

Quote:

Originally Posted by Catalin.B

View Post

try a simple macro...

Hi Catalin,

Can your macro be formatted to copy a date to static text? If I use your formula I get the "40910" results in the copy to column.

Reply With Quote