Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-26-2014, 01:55 AM
jadess916 jadess916 is offline Pulling 2 digits before a decimal point from adjoining cell then zeros after decimal Windows 8 Pulling 2 digits before a decimal point from adjoining cell then zeros after decimal Office 2010 64bit
Novice
Pulling 2 digits before a decimal point from adjoining cell then zeros after decimal
 
Join Date: Jun 2014
Location: Bay Area
Posts: 1
jadess916 is on a distinguished road
Angry 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.
Reply With Quote
  #2  
Old 06-26-2014, 03:48 AM
macropod's Avatar
macropod macropod is online now Pulling 2 digits before a decimal point from adjoining cell then zeros after decimal Windows 7 32bit Pulling 2 digits before a decimal point from adjoining cell then zeros after decimal Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

very easy:
=MOD(INT(A1),100)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
left function, mid function, right function

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pulling 2 digits before a decimal point from adjoining cell then zeros after decimal 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
Pulling 2 digits before a decimal point from adjoining cell then zeros after decimal Converting decimal to hours jhwtsang Excel 4 05-16-2011 01:36 PM
Pulling 2 digits before a decimal point from adjoining cell then zeros after decimal 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:07 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft