LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 23
Default Decimal portion to a seperate cell???

I'm working on a template form where I would like to be able to sum a
column then post the whole number portion of the sum to one cell and the
decimal portion of the sum to another cell. How could this be
accomplished?

BrianG



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
add two cells from seperate work sheets into a cell on seperate wo lar Excel Worksheet Functions 6 April 27th 10 06:54 PM
vLookup a portion of a no. in a cell kattay Excel Worksheet Functions 3 September 23rd 09 04:18 AM
Extract portion of a cell Secret Squirrel Excel Discussion (Misc queries) 4 October 26th 08 05:24 AM
excel formula referring to a decimal portion of another cell teenerx5 Excel Worksheet Functions 1 February 24th 07 05:58 PM
how do i operate on the decimal portion of a number maintchief New Users to Excel 3 October 24th 05 06:43 PM


All times are GMT +1. The time now is 07:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"