data change how to convert to original

[gsrikanth]

original

while converting to excel number changed why? iwant sum the three column

3-65 is convert to 23805
i want 3.65 integer value to calculate

[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.

[gsrikanth]

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?

[gsrikanth]

Originally Posted by gsrikanth

where is march, where in year in 23802?

In cell 8/03/1965 there is no '-' to search&replace

[Pecoflyer]

read this page to better understand what JB means

[gsrikanth]

Originally Posted by Pecoflyer

read this page to better understand what JB means

thanks Pecoflyer

Problem is almost solved

but 1 thing

how to convert days to date,month,year?

[Pecoflyer]

Do you mean a number of days, or a date under it's "xl" form (sthg like 40783 fi)