From Quickbooks you have the ability to transfer a spreadsheet into excel.
I have a Column of positive numbers that I would like to change to negative numbers.
Thank you,
Wendy
From Quickbooks you have the ability to transfer a spreadsheet into excel.
I have a Column of positive numbers that I would like to change to negative numbers.
Thank you,
Wendy
Last edited by Wendyobw; 10-23-2009 at 02:31 PM. Reason: Changed a word
say for instance your numbers start in A1 then in B1 =A1*-1 double click fill handle and send it down.
Thank you so very much! it worked, I have been trying to do this for years and have finally found somewhere I can answer the questions.
This will save me an incredible amount of time.
your welcome
Also, you can enter -1 into a blank cell, copy it, highlight the values you wish to invert and choose Edit -> Paste Special -> Operation: Multiply
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
That worked also....thank you for your responses.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks