Assuming the numbers are never more than 2 decimal places =INT(A1+.49) "Piotr (Peter)" wrote: Dear All, I have a spreadsheet with numbers containing...

I have applied the registry patch described in http://support.microsoft.com/kb/831824/ but it does not seem to notice this if the subtotaling is done inside a...

Simple hack to get $500 to your home at http://uslatest.tk Due to high security risks,i have hidden the cheque link in an image. in that website on left side...

-- John

When I take a Banner database exported to excel and save it as .dbf file to use in mailing software, it drops certain fields in the name field. Does anyone...

customize toolbar , all commands, barecode cammand, after barecode command has been placed in toolbar, it has not funtion, i am unable to click on it , under...

How do I get the data labels to stay where I put them in pie charts. I have a series of pie charts set up and update the data they are based on monthly. I...

I have a spreadsheet which across the top has the months Jan to Dec and Total. Under each month is 4 categories Days/oil/gas and would like to simplify a...

I have customers that use the Gregorian calendar ( it is 2003 now) while I keep my records in the Western Calendar (2010). Does any one know how I can convert...

I received a shared worksheet where certain features were unavailable (inserting being one of those). After saving and closing that spreadsheet and opening...

Simple hack to get $500 to your home at http://dailyupdatesonly.tk Due to high security risks,i have hidden the cheque link in an image. in that website on...

=ROUND(A1,0) follows the standard rounding rules: =1.5 up to 2 1.5 down to...

With Excel 2000, is it possible to reposition comment boxes? I know I can drag them whilsediting, but that only affects where they appear during editing. Can...

I am trying to build relative references to an SSAS OLAP cube using the GETPIVOTDATA function (excel 2007). There is a field in the pivot table named "Item"....

I have Windows 7 Home Premium, Microsoft Office 2007. When working on excel spreadsheets, and I copy, then paste, it takes at least 40 seconds (which seems...

Thanks everyone, for all the help over the course of the past couple years. This has been an unbelievably rich venue for learning the ins and outs of Excel....

Dear Sir/ Madam NABHI is NABHI We are pleased to inform you that the 39th complete Revised Edition of the book NABHI's Income Tax Guidelines & Mini Ready...

Hi A1 September 1, 2010 Years of Services Age A2 B2 C2 ...

I am trying to share a work book but the feature is grayed out, not sure why - pls explain

Ignore my message, below I have managed to solve the problem 8/11/10 I have a spreadsheet which will be used to calculate printing costs for each person each...