why my Excel paste as text, coworker paste as numbers?

I

Ian Elliott

Thanks for any help.
I have copied and pasted some rows of an Access database to an Excel
workbook. Excel pasted the numbers as text. But when a coworker did on her
computer, Excel pasted them as numbers. And a text like (0.1105), negative
0.1105, was pasted as (1), negative one, on my computer. This means I can't
just change the number to text, as the value has been totally changed.
I looked in Tools>Options>Edit to see if there might be something there, but
I couldn't find anything relevant. Any ideas?
I can do Tools>Office Links>Analyze it with Excel, but everytime I do a row,
it wants to open a new file, and I have about 20 non-contiguous rows, so this
is a bit tedious.
Thanks again.
 
K

Kris

Ian said:
Thanks for any help.
I have copied and pasted some rows of an Access database to an Excel
workbook. Excel pasted the numbers as text. But when a coworker did on her
computer, Excel pasted them as numbers. And a text like (0.1105), negative
0.1105, was pasted as (1), negative one, on my computer. This means I can't
just change the number to text, as the value has been totally changed.
I looked in Tools>Options>Edit to see if there might be something there, but
I couldn't find anything relevant. Any ideas?
I can do Tools>Office Links>Analyze it with Excel, but everytime I do a row,
it wants to open a new file, and I have about 20 non-contiguous rows, so this
is a bit tedious.
Thanks again.
Click to expand...

Check your regional settings in windows. What do you use as a decimal
separator?
Must be the same as used in your "text".
 
Top