In Excel (both v.2003 and v.2010, Italian, but with international settings about decimals), I have the following behaviour.
PROBLEM:
When I copy from Word to Excel some numbers that are answers to a multiple-choice test , the numbers turn in something else: not all only some of them.
EXAMPLE:
For instance (to put it simple): 1.60. (notice the last period that closes the answer, and that it is necessary in my test) turns in Excel as 0.083333333. It seems that Excel interprets the numers as something related with hh.mm. It does so even if I digit that number directly to Excel.
RESTRICTION:
I cannot paste as text only, since the answers have some upperscript and underscript text, that will be lost.
QUESTION:
Is there a way to disable the feature of Excel that turns sometimes a number with a last "." in something else? Thank you.
Bookmarks