Excel import from Money

camioneur | 11:24 Thu 08th Mar 2007 | Computers

2 Answers

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

how to protect a modem from surge/spikes.

Freecom DVB-T USB TV Stick Digital TV tuner question

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.

kempie

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/

camioneur

Question Author

Thanks kempie, installed , working, job sorted. Superb thank you

1 to 2 of 2

Do you know the answer?