Text auto formatted as date format

		Microsoft Office Forums > Microsoft Excel > Excel
Text auto formatted as date format

FAQ

Mark Forums Read

Thread Tools

Display Modes

08-21-2013, 09:46 AM

Aikeedoh

Windows 7 64bit Text auto formatted as date format

Office 2013

Novice

Join Date: Aug 2013

Posts: 2

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

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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 12:33 AM.