|
|
|
|
3 |
409 |
|
|
problem converting delimited text to Excel by
Mukesh Thakkar
I have a text file with these two lines
"37-3'3"","93-23'30"",
"39-9'39"N","94-34'49"W",
(This is latitude, longitude information)
When I open the file in...
|
July 22nd, 2004 12:24 AM
by hgrove
|
3 |
743 |
|
|
Visual Basic Error 400 by
kraljb
I just upgraded from 2000 to 2003
I have quite a few macros that load up when I start excel, one of which
is now causing an error message that just has a red...
|
|
1 |
423 |
|
|
.xyz files by
Wynn
Any ideas on how to work w/ .xyz files? I can open them
in Excel, but it looks like a lot gets cut off. I can't
get them to open in Access.
|
|
1 |
232 |
|
|
Sort Names -- Names, Sort by
ClaireView
We have many worksheets of data. Some names are entered "First Last" in one cell, some are entered "Last, First" in one cell. Once I've separated the two...
|
July 22nd, 2004 12:05 AM
by JulieD
|
6 |
184 |
|
|
|
|
0 |
244 |
|
|
Data validation failures by
RogerNZ
I have several templates set up that are called by a master sheet. These sheets contain information with Data validation drop down lists. Excel is continually...
|
|
1 |
482 |
|
|
Multiple Conditions Formula Help Needed by
chiwavdg
I currently have a formula that I have used to calculate commision
rates. We had a 2 rate plan. If sales were below a certail threshold
then apply this rate...
|
|
3 |
443 |
|
|
CountIf on 2 columns by
JC
I have 2 columns of data, Profit $ and Profit %. I would
like to get a grouping of different counts. For example,
the number of items with Profit $ 500 and...
|
|
4 |
190 |
|
|
To write formulas in cells using VBA by
Hari
Hi,
Is it possible to put a formula in a worksheet through VBA.
I have 2 cells Q3 and Q4 where I want to have formulas -- =IF(D30,D3,"")
and...
|
|
7 |
552 |
|
|
Excel data merged to PDF form by
kimt
Would like to use data from an existing excel data base for use in a PDF
form (W4 - witholding or similar). Can this be done, have had no luck
reformating the...
|
|
2 |
400 |
|
|
Converting columns to rows for mail merge by
Wes61
Hello,
I have an Excel Spreadsheet (2002 vers.) that I need to merge into a letter. The spread sheet is 25,000 line items.
The information is listed in...
|
|
6 |
662 |
|
|
Convert devimal to number format by
Richard
I am sent a spreadsheet that lists performances in a time
trial. The times are entered in Excel as decimal ie. 23
mins 20 secs is entered as 23.20. I need...
|
|
5 |
340 |
|
|
[Group] in workbook title by
emmiek
hi-
i've had to make a single edit across 90 some-odd sheets in an excel file.
i did this by selecting sheet 1+shift+sheet90
sometimes the title of the...
|
July 21st, 2004 08:57 PM
by Hari
|
3 |
206 |
|
|
Wrapping Text to next cell? by
bdunk
Is it possible to get text that overfills a cell to wrap to the next
cell below it?
thanks Brian
---
Message posted from http://www.ExcelForum.com/
|
|
1 |
325 |
|
|
Excel Icon changed to different Graphic by
Jean Larson
Hi,
The other night a friend of mine noticed that all of a sudden all his
Excel workbook files had a new icon. It used to be a spreadsheet with
an X on the...
|
|
3 |
313 |
|
|
Date/Serial Number by
SallyNBS
Hoping you can help me quickly.
I exported a report from QuickBooks to Excel. Everything exported correctly and I am manipulating how the report looks. All...
|
|
3 |
161 |
|
|
linking Excel table to word by
Thrava
Can anyone tell me how I can have an excel table linked to
a word table so that the word table dynamically updates
itself based on the values in excel...
|
July 21st, 2004 07:58 PM
by thrava
|
3 |
387 |
|
|
date formatting by
Format the cell for a date, and if it doesn't have that
particular style you can customize it to be your style.
-----Original Message-----
I want to enter...
|
|
2 |
160 |
|
|
text to column code / invalid syntax by
Vato Loco
I was trying to use this code to automatically delimit cells upon
opening the workbook but it is not working. Can someone tell me what is
going wrong?
Sub...
|
|
1 |
293 |