Formula to convert dates into text/values

		Microsoft Office Forums > Microsoft Excel > Excel
Formula to convert dates into text/values

FAQ

Thread Tools

Display Modes

07-01-2019, 06:53 AM

Marcia

Windows 7 32bit Formula to convert dates into text/values

Office 2013

Expert

Join Date: May 2018

Location: Philippines

Posts: 551

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Concatenate to reference values with that are dates	Glitch	Excel Programming	3	08-03-2018 02:58 PM
IF formula when some values are text & others $ amounts	LyndaH	Excel	4	03-26-2017 08:31 PM
How to convert VLOOKUP values to text on another sheet AUTOMATICALLY	Lady18	Excel	5	09-10-2016 03:12 AM
How to convert VLOOKUP values to text on another sheet AUTOMATICALLY	Lady18	Excel	1	09-10-2016 12:15 AM
Convert Formula Result to Static Text	MYGS	Excel	16	01-21-2013 08:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:09 PM.