General
in [Excel]
|
Quttro pro, QPW file Any ideas how to open a Quttro pro file with the extension .QPW in excell XP? ... 22 Feb 2005 18:14
Compare and Merge command grayed out. I have two nonshared workbooks that need to be merged Wk bk 3 into wb 1 after comparing Here's content from them: Workbook 1 FIRM_NO FLEET_NO UNIT_NO Renewed PLATE_NO AXLES VEH_MAKE 7206 1 526311C Y P00438585 2 FRTL 7206 1 90478A Y P00417552 3 INTH 7206 1 525777A Y P004... 22 Feb 2005 18:14
BIMDAS - Order of Calculation I've recently noticed that Excel flies in the face of standard scientific, mathematical and engineering convention in the calculation of powers for numbers that are then multiplied by a negative. The convention of mathematics, "BIMDAS" (or similar acronyms), states that _I_ndices (or powers, or exponents), sho... 22 Feb 2005 22:36
How do I create a monthly/fortnightly employee roster/timesheet? Excel timesheet including variable start and finish times for different employees over a fortnightly period. Should be capable of charting numerous employees and indicating when they are on annual leave, on call, rostered on, over-time etc. Different coloured cells would indicate different duties ie. ROSTERED ON... 19 Feb 2005 23:28
How do I open a .wks file (worksheet) in an Office XP product? I received by Email a Microsoft "Works" file made using the spreadsheet option in Microsoft Works. I want to know if and how I can open this file using an Office XP application, and which one. It doesn't make sense that two Microsoft products are not compatible. ... 19 Feb 2005 12:10
acSpreadsheetTypeExcel in VBA you get import or export options for spreadsheets - in 2003 it gives options such as 'acSpreadsheetTypeExcel5' whereas in v97 - it would just give the version number. What is the equivalent spreadsheet type in 2003 for importing v97 spreadsheets? ... 19 Feb 2005 23:28
string comparisons Hello, Does anyone have any suggestions for creating an excel formula for finding the difference between two strings of numbers that are separated by commas, but are not in ascending order? For example, the formula output of "5,7,1,3" and "3,7" would be "1,5" or "5,1". I know this could be done by VBA u... 17 Feb 2005 12:06
Time - Hours and Minutes I need to enter negative time value (hour and minutes) in a table calculating tides for secondary ports, for example 13:00 hours minus a negative value such as 00:15 hours, i.e., 13:00 - (-00:15). Excell will not allow negative time entry, is there any other way? Appreciate your assistance Regards Mark Zak ... 17 Feb 2005 21:18 |