Hi all.
Hope you can help.
目前分類:title (4957)
- Nov 03 Mon 2008 20:47
Change XY tick labels from numeric to text
- Nov 03 Mon 2008 20:47
Using colors outside the standard palette
Greetings all -
I'm trying to format a cell with a custom color (RGB values 182,214,0). How
- Nov 03 Mon 2008 20:47
lookup and count
I have the following type data and need to first lookup by the dealer # and
then count the model number but need to use wild cards.
- Nov 03 Mon 2008 20:47
save a spreadsheet file with same name but different version
- Nov 03 Mon 2008 20:47
data validation and formatting
I want users to be allowed to enter a seven character response in a cell.
The seven character response must be in the following format - number number
- Nov 03 Mon 2008 20:47
Path to Lookup from another document
Hi, first post ever ever! Can you help?When using worksheet quot;Aquot; I want an equation to look at one cell
- Nov 03 Mon 2008 20:47
duplicate numbers in column a and diferent values in b
My file has account numbers in column A. Some may be duplicates, some may
not. In column B their are different values for each account. In column C
- Nov 03 Mon 2008 20:47
How to make excell ignore non-whole numbers
- Nov 03 Mon 2008 20:47
unique order number according to criteria
I have the following slate numbers in a column but they do not run in this
numerical order.
- Nov 03 Mon 2008 20:47
Autosave.xla add-in: how to edit default settings
I use the Autosave.xla add-in. When I open Excel, Autosave is set to save
every 10 minutes and it requires a prompt. I can change that to 5 minutes and
- Nov 03 Mon 2008 20:47
Can I change the default sheet name?
I would like to change the default worksheet name of Sheet1 to 0001 to
continue 0002, 0003 and so forth. Is there an option where I can change that
- Nov 03 Mon 2008 20:47
Where do I enter the PROPER formula in a spreadsheet?
I have a spreadsheet with data containing UPPERCASE. I need to use the
PROPER formual and do not know where to enter this formula on the spreadsheet.
- Nov 03 Mon 2008 20:47
How do I assign dollar value to text
I am putting together an invoice spreadsheet for Voice Overs. I want to be
able to type :30 in Column D and have the value of $35 to appear in Column F.
- Nov 03 Mon 2008 20:47
Prevent duplicate entries in Excel 2000
I'm trying to create data validation to prevent users from entering duplicate
rows in Excel 2000. I tried this also with conditional formatting to turn the
- Nov 03 Mon 2008 20:47
To Calculate age in a cell
I am entering Date of birth in a cell and i would like to calculate age in
another cell. how to do about it ?
- Nov 03 Mon 2008 20:47
How to hide columns that are not filtered?
Hello,
- Nov 03 Mon 2008 20:47
Moving beteween sheets using the tab button
I'm using XL 2003 and i want to use the tab button to move between the
different tabs/Sheets in a workbook.
- Nov 03 Mon 2008 20:47
How do I recover a previous save point in Excel?
I had some data deleted from an Excel document and saved after it was
deleted. It would take hours upon hours to retype. How can I restore to a
- Nov 03 Mon 2008 20:47
How do I use the Color Index to format my cells which requires mo.
I would like to format the cells using conditional formating but
unfortunately it allows only for three conditions.
- Nov 03 Mon 2008 20:47
Date formula that adds 7 days to a cell when sheet is copied
I am triying to create a formula that will insert a date based on a date that
is one week later. I want it to create a date when I copy a sheet and create