View Single Post
 
Old 12-29-2011, 11:34 PM
JBeaucaire JBeaucaire is offline Windows XP Office 2003
Advanced Beginner
 
Join Date: Dec 2011
Posts: 51
JBeaucaire is on a distinguished road
Default

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.
Reply With Quote