#1
|
|||
|
|||
data change how to convert to original
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
Quote:
|
#4
|
|||
|
|||
In cell 8/03/1965 there is no '-' to search&replace
|
#7
|
||||
|
||||
Do you mean a number of days, or a date under it's "xl" form (sthg like 40783 fi)
__________________
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 |
|
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 |