![]() |
Excel still changes numbers to date
Hi,
i have this problem, when Iam copying numbers (like 5.6) from web page and will paste it to excel, then excel will change this number to date format (in this case 5.6.2006). I can change just manually. But Iam working with a lot of numbers and its not best way. Can someone help me how to disable this automatic changing please??? |
Excel still changes numbers to date
One way is to format destination cells as text before importing data.
Regards, Stefi €˛Libor€¯ ezt Ć*rta: Hi, i have this problem, when Iam copying numbers (like 5.6) from web page and will paste it to excel, then excel will change this number to date format (in this case 5.6.2006). I can change just manually. But Iam working with a lot of numbers and its not best way. Can someone help me how to disable this automatic changing please??? |
All times are GMT +1. The time now is 08:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com