Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a very long list of positive numbers that I have converted from a
wordpad report. Actually it is our list of receivables. They have been converted from text, and therefore the ones that should be credits, or negative numbers (in context of receivables) appear as just plain positive numbers, such as 150.00. I don't know of a simpler way to turn these numbers to negative (i.e. -150.00) without F2'ing each one and putting a minus (-) sign in front of each one. It would save me so much time just to be able to change these numbers from positive to negative! If you could help me I sure would appreciate it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating growth with negative numbers | Excel Worksheet Functions | |||
Erf (the error function) for both negative and positive numbers | Excel Discussion (Misc queries) | |||
can the negative numbers in an IF statement be in a diff color th. | Excel Worksheet Functions | |||
Negative numbers turn positive automatically on data entry | Excel Discussion (Misc queries) | |||
highlighting positive or negative change | Excel Discussion (Misc queries) |