Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Negative Numbers (2000)

    I have a column of numbers that are defined as General. They have an apostrophe in front of them. I want to change them to a number so I put =Value(A1) and copy down. The column I copy them to is formatted for number, 2 decimal places and negative numbers appear with -999.99. My problem is that the negative numbers in the column are entered as text with the negative sign to the right. When I copy down my formula, I get #VALUE! for the numbers with the negative sign to the right. Is there an easy way to change these to a negative number? Thanks for your help.......

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Negative Numbers (2000)

    Try this formula:
    <pre>=IF(RIGHT(A1,1)="-",-VALUE(LEFT(A1,LEN(A1)-1)),VALUE(A1))</pre>


    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •