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

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?

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

read this page to better understand what JB means

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

thanks Pecoflyer

Problem is almost solved

but 1 thing

how to convert days to date,month,year?

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

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post