Thread: [Solved] data change how to convert to original
View Single Post
 
Old 12-30-2011, 01:47 AM
gsrikanth gsrikanth is offline Windows XP Office XP
Competent Performer
  
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default
Quote:
Originally Posted by JBeaucaire View Post
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?
Reply With Quote