| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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??? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Date Format - users should be able to override it automatic. | Excel Discussion (Misc queries) | |||
| Excel 2007 Date Format Problem | Excel Discussion (Misc queries) | |||
| excel array formula | Excel Worksheet Functions | |||
| date format in excel not in line with control panel regional setti | Excel Discussion (Misc queries) | |||
| How do I stop Excel from changing numbers into a date? | Excel Discussion (Misc queries) | |||
Linear Mode
