Pages

Search

Excel Help Forum - Excel Charting & Pivots: [SOLVED] Grouping dates - Formatting Issue?

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
[SOLVED] Grouping dates - Formatting Issue?
Hi, I'm trying to create a pivot table on the data in the attached file and grouping the expenses into months by right clicking on the data column and selecting "Group". EXCEL gives me an error message "Cannot group that selection". I'm pretty sure it's something to do with the format of the...

Excel Help Forum - Excel Charting & Pivots: Grouping dates - Formatting Issue?

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Grouping dates - Formatting Issue?
Hi, I'm trying to create a pivot table on the data in the attached file and grouping the expenses into months by right clicking on the data column and selecting "Group". EXCEL gives me an error message "Cannot group that selection". I'm pretty sure it's something to do with the format of the...

Excel Help Forum - Excel General: [SOLVED] sum non-formula numbers

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
[SOLVED] sum non-formula numbers
I have a column mixed with numbers derived from formulas and also numbers manually added (Column B Row 1 through 55). In cell A1 I wish to put a formula to sum all the manual numbers only. What would that formula be? Regards, Gary

Excel Help Forum - Excel General: sum non-formula numbers

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
sum non-formula numbers
I have a column mixed with numbers derived from formulas and also numbers manually added (Column B Row 1 through 55). In cell A1 I wish to put a formula to sum all the manual numbers only. What would that formula be? Regards, Gary

Excel Help Forum - Excel General: Excel 2010 changes date format

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Excel 2010 changes date format
I am having trouble with Excel 2010 not displaying correctly the date formats. For example, I have the following date format in my database table (dd-mmm-yyyy) and in the related pivot table I get the following date format (mmm-yy). I tried removing the field from the pivot table and then...

Excel IT Pro Discussions Forum: Calculate Loan cost with extra payment Excel

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Calculate Loan cost with extra payment Excel

What I am trying to do is weigh the cost of refinancing as compared to simply making a higher payment equal to the new higher payment.  So in other words my I have already calculated the total cost of my current loan which has a payment of about $500 at for 28 more years at 5%.  I have also already built the total cost of my new loan at payments of $750 over 15 years at 2.75%.  However I want to further determine how much I am saving with the new loan compared to the old loan if I were to simply make a $750 payment on my old loan.  

The key is if I can avoid it I do not want the entire amortization schedule for the new loan because I am trying to compare to about 12 different loan options.

P.S. I tried to include a screen shot by MS won't let me for some reaon

Excel Help Forum - Excel General: How to convert number to number stored as text excel 2007

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
How to convert number to number stored as text excel 2007
hi all, i know how to convert number stored as text to number but how to convert number to number stored as text excel 2007? please help.