Food & Drink1 min ago
Excel import from Money
When I use MS Money and export a list of transactions to Excel the transactions are always in a negative number format. i.e. -98.99. When I then create an accounts sheet in Excel which is the purpose of the export I want the numbers to appear in a positive format i.e. 98.99.
My question then is; is it possible to change all the numbers in a spreadsheet from negative to positive without doing each one individually and still retain their values i.e.-98.99 becoming 98.99. TIA
My question then is; is it possible to change all the numbers in a spreadsheet from negative to positive without doing each one individually and still retain their values i.e.-98.99 becoming 98.99. TIA
Answers
1 to 2 of 2
Best Answer
No best answer has yet been selected by camioneur. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
There may well be a way to achieve this within Excel itself, but may I suggest that you install an Excel add-in named ASAP Utilities which offers many useful tools for data manipulation, one of which enables you to convert negative numbers to positive.
http://www.asap-utilities.com/
http://www.asap-utilities.com/
1 to 2 of 2
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.