AGRIS Customer Documentation
Moving Negative Sign from End of Number to Beginning in Excel
How to get rid of the hyphen (negative sign) at the end of a number so Excel recognizes as numeric figures
Select cells
Go to data
Choose Text to Columns
On screen 3 of “convert text to columns,” go to the advanced button
Checkmark the “Trailing minus for negative numbers” box
Select ok AND Finish
The highlighted fields become a number with hyphen (negative sign) in front and can now be used for calculations in Excel
3820 Mansell Road, Suite 350 ✦ Alpharetta, GA 30022 ✦ www.GreenstoneSystems.com
© 2011 - 2024 Cultura Technologies LLC. All Rights Reserved Worldwide. Products and company names mentioned herein may be trademarks or registered trademarks of their respective owners.