Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 08-21-2013, 09:46 AM
Aikeedoh Aikeedoh is offline Text auto formatted as date format Windows 7 64bit Text auto formatted as date format Office 2013
Novice
Text auto formatted as date format
 
Join Date: Aug 2013
Posts: 2
Aikeedoh is on a distinguished road
Default

Bob,

Sorry for not being clearer. Yes, the cell is displaying "100:03:00", but when I do a VLOOKUP from another sheet, the returned value is not "100:03:00", but instead it is returning a different value "4.16875". What can I do to have the returned value displayed as "100:03:00"?

Thanks
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Text auto formatted as date format AutoCorrect with Formatted Text pmokover Word 16 10-30-2024 02:50 AM
Auto Date klaws Outlook 0 08-24-2012 01:01 PM
date format gsrikanth Excel 1 12-28-2011 05:06 AM
Import formatted text from Word into PowerPoint parboy PowerPoint 0 07-06-2011 08:52 AM
Auto Update the date. Nirik Excel 16 12-16-2010 04:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:18 AM.


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