I have an excel file that has numbers stored as negative numbers. How can I convert the number to a positive?
In the cell that you want the data to be converted write either =(C5-C5)-C5 or =C6-C6-C6
C is the cell where the negetive data is.
TIP; if you want to delete the negetive data after converting then mind to copy > past special > values, the converted data.
Seems like a lot of work. Won't =Abs(C5) do the same thing?
Hmm you are right. but thats how much i knew. anyway let him to choose whatever he wants. BTW thanks for ur ans as i have learned something too
Thanks for the responses.
My problem is that I about 1500 records that I need to convert to positive numbers and the numbers are not the same. I am not following the Abs function. Can someone please provide me with more detailed instructions on how to do this function. When I try - I end up changing all the records to the same number.
Thanks for the responses.
My problem is that I about 1500 records that I need to convert to positive numbers and the numbers are not the same. I am not following the Abs function. Can someone please provide me with more detailed instructions on how to do this function. When I try - I end up changing all the records to the same number.
Is there away to convert decimal places as 1,000s? My numbers are currently 15.031 (which is 15,031).
I don't think that will work. Some numbers are 100's (0.125)
These are actual numbers not text