Results 1 to 4 of 4

Thread: Pulling 2 digits before a decimal point from adjoining cell then zeros after decimal

  1. #1

    Angry Pulling 2 digits before a decimal point from adjoining cell then zeros after decimal



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi, I have been trying to figure out how to pull the last two digits before a decimal point from an adjoining cell so those digits show up in the cell next to it with the digits after the decimal displaying as zeros.

    Cells in A column displays $ABCD.EFG
    and I want Cells in the B column to display $CD.00

    What I mean is:

    A
    B
    $6790.980
    $90.00
    $7982.764
    $82.00
    $2948.286
    $48.00



    Any help would be eternally appreciated. THANKS soooo much if you figure this out. I'm relatively new to excel so this is complex stuff for me.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Try:

    =MOD(INT(A1),100)


  3. #3
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Crossposted elsewhere. Please post your links to your thread in other forums.


  4. #4
    Thanks!!!!

Tags for this Thread

Posting Permissions

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