This topic has been archived. It cannot be replied.
-
工作学习 / 专业知识杂谈 / Help!!! Excel Problem.I copied some datas from internet and then pasted them into Excel sheet. When I did some calculation, it said that the value used in formula is of wrong data type. However, I changed data type, but it still didn't work. I couldn't figure it out.
-littleriver(running river);
2006-9-19
{248}
(#3216015@0)
-
up! Anyone knows. There are too much datas to type in. It has to have some way.
-littleriver(running river);
2006-9-19
(#3216033@0)
-
I copied some datas from internet and then pasted them into Excel sheet. When I did some calculation, it said that the value used in formula is of wrong data type.
-littleriver(running river);
2006-9-19
(#3216035@0)
-
copy the data on excel spreadsheet and paste again by using paste special (select values), should do the conversion for u.
-sunday8(sunday8);
2006-9-19
(#3216148@0)
-
F2
-7y7(醉里吴音);
2006-9-19
(#3216152@0)
-
对于特别复杂的数据表格，我通常先拷贝到 Notepad，再 copy+paste到Word，然后转换为表格形式，再 copy+paste 到 Excel.
-rollor(Rollor);
2006-9-19
(#3216221@0)
-
数据后面有空格， 删了就好了
-zxcvb(朝天椒);
2006-9-19
(#3216231@0)