data change how to convert to original

		Microsoft Office Forums > Microsoft Excel > Excel
data change how to convert to original

FAQ

Thread Tools

Display Modes

12-30-2011, 01:47 AM

gsrikanth

Windows XP data change how to convert to original

Office XP

Competent Performer

Join Date: Dec 2011

Posts: 133

Quote:

Originally Posted by JBeaucaire

When you converted from text it recognized 3-65 as the date March 1, 1965. The numeric value for that date is 23802, the next day is 23803, etc.

To convert those text entries into numerics, do a SEARCH/REPLACE on that text first to convert the dashes (-) into decimals. See if your results are better after that.

where is march, where in year in 23802?

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Outlook 2010 - Change default data file.	siouxnami	Outlook	4	01-26-2012 12:24 PM
original doc in 3 new files	Michael007	Word VBA	3	12-11-2011 01:57 AM
How to restore original data format - from a .pdf file to Excel columns	KIM SOLIS	Excel	1	09-18-2011 10:49 PM
Macro to loop in subfolders, change links, export xml data	Catalin.B	Excel Programming	2	09-08-2011 11:37 PM
re change data in a monthly work book	primaxuk	Excel	1	10-22-2009 08:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:38 PM.