Microsoft Office Forums - View Single Post - [Solved] Formula to convert dates into text/values

Thread: [Solved] Formula to convert dates into text/values

View Single Post

Old

07-01-2019, 06:53 AM

Marcia

Marcia is offline

Marcia uses Windows 7 32bit

Windows 7 32bit Marcia uses Office 2013

Marcia uses Office 2013

Office 2013

Expert

The original poster

Join Date: May 2018

Location: Philippines

Posts: 527

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Default

Thank you for giving three options, from which I chose formula number 1. The second and third formula compute Dec 1937 as 13850 even if it is formatted as text.

Reply With Quote