ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel still changes numbers to date (https://www.excelbanter.com/excel-discussion-misc-queries/120356-excel-still-changes-numbers-date.html)

Libor

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???

Stefi

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