Negative / postive numbers

**Diana2013** · 05-14-2013, 11:00 AM

I have a Peachtree report that has negative and positive numbers in it that I am copying to a Excel report. If the number is positive in Peachtree then it will negative in Excel. If the number is negative in Peachtree then it will positive in Excel.

Example: Peachtree = B14 = -2.07 Excel = F103 - 2.07

Thanks for your help!
Diana

**martindwilson** · 05-14-2013, 11:12 AM

so you want to change the sign of everything you have copied in?
if so put -1 in a spare cell copy it
select range you want to change right click paste/special/multiply