|
|
Text shows up at all # symbols by
AKMMS
I received an Excel file, and for an unknown reason, the text in just one of
the cells displays as all # symbols, even though I can see actual text in the...
|
|
3 |
928 |
|
|
Automatically update worksheet name by
JuneS
Is there a way to change the names of worksheets automatically? I use Excel
2007 for invoicing, but it's really a pain to have to rename each sheet to...
|
|
1 |
884 |
|
|
Macro to sort variable data range fails by
Kiwipingu
Hi,
Can you please help me identify why this macro is failing with the
following error?
Runtime error 1004: Sort method of Range class failed
Row 7 is the...
|
|
1 |
1,007 |
|
|
Break up a name by
Jim
Hello,
I ahve a list of names, with middle initials, that I need to break up. For
example the names are formatted like the following:
Bayer, Daniel E.
I...
|
June 3rd, 2010 09:26 PM
by Jim
|
3 |
969 |
|
|
|
June 3rd, 2010 09:12 PM
by ??4Pat
|
0 |
878 |
|
|
File in Exclusive Use by
SSi308
I have searched this forum and Excel help and cannot find the answer to my
seemingly simple question.
How does a user take a file out of exclusive use?
We...
|
June 3rd, 2010 08:59 PM
by SSi308
|
3 |
966 |
|
|
file with udf extension by
Ruth
Hi
I have a file with a udf extension. When I searched the several sites said
that it was related to excel, so I opened it with excel. When opened, it is...
|
|
2 |
1,205 |
|
|
Msg: "Drawing Objects...protected" won't save by
christophercbrewster via OfficeKB.com
I'm using an XLS spreadsheet in Excel 2007, and I can't save it in either the
old or new format. the message says "Drawing Objects in one or more sheet(s)
in...
|
|
2 |
1,287 |
|
|
|
|
1 |
850 |
|
|
Text Qualifiers by
Wavequation
I imported a tab-delimited text file, with quotation marks as the text
qualifiers. Excel removed the marks, and now I need to save the file back as
text,...
|
|
1 |
1,066 |
|
|
Remove preceding zeroes? by
hds
I want to enter a value as .050 x 27.5 in a cell. I can due this by
formatting the cell as text, but when I copy to a new cell I get 0.050 x
27.5. Formatting...
|
|
1 |
834 |
|
|
Sumif and vlookup Help by
Nikki
Can you please help me with setting up a formula?
Product A = $100
Product A = $100
Product A = $300
I want my result to be Product A = $500 not $100....
|
June 3rd, 2010 06:54 PM
by John
|
2 |
907 |
|
|
Deleting cliparts in excel sheet by
Karina
I have an excel sheet in wich I paste everyday new information, replacing the
previous day information. There's a clipart that has been pasted over and
over,...
|
|
7 |
985 |
|
|
|
June 3rd, 2010 06:24 PM
by John
|
2 |
935 |
|
|
|
|
4 |
1,184 |
|
|
"$" command will not work in VISTA by
sjwillow
Hello,
Does anyone know why the "$" command will not work in formulas when running
VISTA? Does anyone have a solution?
A simple version of my problem...
|
|
4 |
856 |
|
|
Average value only for the filtered area.. by
Sasikiran
Dear,
I have data in the range of cells A2:E1000. The row 1 has the headers to
which i had given filters.
The column E has a numeric value for which an...
|
|
4 |
917 |
|
|
Where is the Object section? by
gudencough
I need to put a sub command into the object section for a formula to work.
However i am not understanding what or where the object or object section is.
Does...
|
|
4 |
880 |
|
|
How do I save Pivot Table Data by
webeinky
Hello,
I have created a Pivot Table in a Excel 2007 Template which uses the data
from an Access 2007 table. In my Connection Properties I have all the...
|
|
4 |
970 |
|
|
|
|
1 |
933 |