Excell spreadsheet problem

Discussion in 'Software' started by davidmarley, Jan 31, 2010.

  1. davidmarley

    davidmarley Private E-2

    I am working in a excell spreadsheet and have 2 columns

    In 1 column I have -£100.00, I need to make this number a positive
    number in column 2. 1 2
    -£100 = £100

    How do I convert a negative to a positive number?

    Many thanks

    David
     
    davidmarley, Jan 31, 2010
    #1
  2. GermanOne

    GermanOne Guest

    Hi davidmarley,

    if column A is formatted as currency, there is a worksheet function called ABS. Write to B2
    =ABS(A1)

    Regards
    GermanOne

    BTW This has nothing to do with "Programming".
     
    GermanOne, Jan 31, 2010
    #2
  3. davidmarley

    davidmarley Private E-2

    I will try the above, Thank You for the quick reply.
     
    davidmarley, Jan 31, 2010
    #3

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds