removing spaces between the numbers
Hello all!
When copying number from Navision account program to Excel, it copies
numbers with spaces as text, but not as numerical values.
Such value: 1 109 014,08 is copied as text.
One possibility to set the number actually to a numerical value is to delete
the spaces within the number, so after doing that it looks as 1109014,08.
Then i can add, multiply, divide this number with ease.
Is there a automatic possibility how remove those spaces?
Is there an alterantive?
|