|
|
#2
12-29-2011, 11:34 PM
|
|||
|
|||
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. 
|
|
|
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 |
Windows XP 
Office 2003
Threaded Mode