I have the following three columns, No Weeks= 6, Start Date = 31/3/6 End
Date =12/5/6 . I need a formula to calculate a revised date such that if
目前分類:title (5957)
- Apr 21 Sat 2007 20:37
Formula Required
- Apr 21 Sat 2007 20:37
remove last character in a column of part numbers if a quot;Vquot;
i have a column of different length part numbers and want to remove the last
letter if it is a quot;vquot; only..how do i do that?
- Apr 21 Sat 2007 20:37
replace using *
I am using Excel 2002. I have a column that contains text. Within this text
are multiple *. I would like to replace them with nothing using the find and
- Apr 21 Sat 2007 20:37
Crystal Report 9 Wizard in Office 2003
Does any body know how to use CR9 in Office 2003 like in Office 2002?
- Apr 21 Sat 2007 20:37
Preferences for sorting to always have header row
Can I change the default preferences in Excel to 'My Data has Header Row'? I
often use the icons for sort ascending in the toolbar and the data always
- Apr 21 Sat 2007 20:37
Simple Petty Cash Sheet ?
- Apr 21 Sat 2007 20:37
cell * figure
I have a Price column. It is in US dollar and I need it to convert Canadian
dollars.If the conversion rate is 20% Canadain to Us then US * 1.20.
- Apr 21 Sat 2007 20:37
Saving changes in shared workbooks
Hi, I have a shared workbook that I've been using for years with 4 - 5 users
being able to use and update concurrently. All of a sudden we're experiencing
- Apr 21 Sat 2007 20:37
Multiple Conditions
Hi!
- Apr 21 Sat 2007 20:37
Refresh multiple pivot tables
I have created numerous pivot tables from my original using the PivotTable
and PivotChart Wizard. I selected quot;Another PivotTable report or PivotChart
- Apr 21 Sat 2007 20:37
formula returning incorrect blanks
Problem:
- Apr 21 Sat 2007 20:37
Find the missing number?
- Apr 21 Sat 2007 20:37
Calculating by individual months of the year
Hi all,
- Apr 21 Sat 2007 20:37
Countif Q
I'm trying to Count the number of instances of quot;Yesquot; in Column A (sheet2)
BUT only if the values in Column A (sheet2) = to a value I have in C8 in
- Apr 21 Sat 2007 20:37
automatic sound
- Apr 21 Sat 2007 20:37
VBA to change font?
I have a workbook with several sheets. I inherited this workbook and it has
multiple fonts. I want code to change all fonts to a common font, say
- Apr 21 Sat 2007 20:37
Why is that happen ?
Hi,
i format all cells in D,E,F and G to currency and try to typ for example
- Apr 21 Sat 2007 20:37
format time in 12hr mode without showing AM/PM
Is there a way to format a cell with a generic 12 hour time setup without
showing AM/PM next to the time entered? I need to enter scheduling
- Apr 21 Sat 2007 20:37
How: List in col D whichever number greater; B4 or varying # in Co
Seek help in Excel,
How can a list of numbers be generated in Column D representing the greater
- Apr 21 Sat 2007 20:37
Want to Create a List in Excel 2002; Don't see List in Data Menu?
I want to create a List range in a data-set. I am using Excel 2002. When I am
going to Data Menu; there is nothing like the LIST option. Please suggest!