|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pulling 2 digits before a decimal point from adjoining cell then zeros after decimal
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 column: $6790.980 $7982.764 $2948.286 B column: $90.00 $82.00 $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
|
||||
|
||||
very easy:
=MOD(INT(A1),100)
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
left function, mid function, right function |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Align Mail Merged Numbers to the Decimal Point | HangMan | Mail Merge | 1 | 12-11-2013 02:32 PM |
Forced extra decimal places | Metamag | Excel | 11 | 08-18-2012 03:10 AM |
Converting decimal to hours | jhwtsang | Excel | 4 | 05-16-2011 01:36 PM |
Convert hours in decimal | ghostones | Excel | 1 | 12-29-2009 09:17 PM |
Merge, Too many Numbers right of the Decimal Point | ohdearme | Mail Merge | 0 | 10-25-2009 05:10 PM |