Text auto formatted as date format

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

FAQ

Thread Tools

Display Modes

08-20-2013, 10:18 PM

Aikeedoh

Windows 7 64bit Text auto formatted as date format

Office 2013

Novice

Join Date: Aug 2013

Posts: 2

Text auto formatted as date format

Hi,

I am working on an Excel table with data looking like this 100:03:00. I select the cell and it shows cell's value as 1/4/1900 4:03:00 AM.

I want the cell value to be shown as 100:03:00 as I will be using vlookup function to look for these in another table.

Thanks.

« Previous Thread | Next Thread »

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 03:20 PM.