Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 07-01-2019, 06:53 AM
Marcia's Avatar
Marcia Marcia is offline Formula to convert dates into text/values Windows 7 32bit Formula to convert dates into text/values Office 2013
Expert
Formula to convert dates into text/values
 
Join Date: May 2018
Location: Philippines
Posts: 551
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia 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
 



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
Formula to convert dates into text/values 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.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft