View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
martin
 
Posts: n/a
Default 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?