| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| question about removing text from cells, leaving numbers | Excel Discussion (Misc queries) | |||
| removing unnecessary spaces from multiple cells | Excel Worksheet Functions | |||
| removing firsts two numbers from a list of #s | Excel Worksheet Functions | |||
| Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
| Removing Spaces in a Cell | Excel Worksheet Functions | |||
Threaded Mode
