H2 Convert number with negative sign on right
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: H2 Convert number with negative sign on right

  1. #1
    Guest

    Default

     
    How do you convert downloaded data where the negative sign appears on the right side of a number as opposed to the left? Excel is recgonizing it as text. I tried to format the cell to a number but excel is still reading it as text. i.e. 92.50- needs to be converted to -92.50.

  2. #2
    Guest

    Default

    =VALUE("-" & LEFT(A1,LEN(A1)-1))

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    or
    =IF(ISNUMBER(A1),A1,LEFT(A1,LEN(A1)-1)*-1)

    if you have positives and negatives in your list.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com