Excel still changes numbers to date

L

Libor

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

Stefi

One way is to format destination cells as text before importing data.
Regards,
Stefi

„Libor†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting column width in a table with a macro is not working 0
Excel does not accept text format! 0
Task Information Dialog Box not making duration changes to task 0
Embed the same Excel multiple times 0
Embedded Excel into Word with Tables 0
Numbers change to a date format 4
How to change font & size of (all) citation numbers? 7
Excel cells changes number format automatically 0

Top