i have imported some data from an accounting programme, but the numbers have come in as a text string
eg "345 456,54"
i want to remove the spaces and convert so that excel understands it as a number 345456.54
any ideas?
i have imported some data from an accounting programme, but the numbers have come in as a text string
eg "345 456,54"
i want to remove the spaces and convert so that excel understands it as a number 345456.54
any ideas?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks