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.

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...

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...

Hello, I am creating a time sheet. Any help would be appreciated. I have 4 cells: 1. IN (time cell) 2. OUT ( time cell) 3. Lunch (time cell) 4. Total...

Frank Kabel wrote: Hi for formating prime numbers try the following: 1. Insert the following user defined function in one of your modules (function...

When you hit the ENTER button.. the cursor will move either right,left,up or down... Is there a way to have it move to specific cell for example if your add...

I have the following...

28,000 cells are SUPPOSED to be rounded to 2 decimal places. However, their total is: 28,0004,231,983.34000001000. How do I find the cells containing these...

Hello, Is there any known problem with copying cells with data validation (list) from excel 2000 workbook to excel 2003 workbook ? Copy / Paste - paste the...

I know there is a simple formula for this, but I haven't had to work with this for so long, I just can't seem to pull it from my memory, and I don't know the...

Hi ng Using xl 2003 Need to scrub a text file before submitting Desired output: Inv # || Inv Amnt || Date || FAS? || FAS# Problem:

You get these by clicking on: Window New Window To get rid of excess windows, click on "Close Window" (that's the cross in the top-right of the screen...

Morning All, I am attempting to work out the time in which a customer enquiries been open for. I have the below info: A5 Call date B5 Call Time I5 Todays...

Is there a way to combine columns? I have a spreadsheet with a couple thousand rows. I want to give each row a unique identifier that has the components of a...

Does anyone know of a formula for calculating time from speed and distance? As in d=3 miles; s=45mph; t=00:04 (hh:mm). There must be a standard formula for s....

Hi there, Currently i have a vb statement that will copy a sheet and then save it to a certain location. what im interested to do is to set it up so when i...

When referencing a text field in another column, the formatting of the content does not get copied over. Example: A1 (Text) This is formatted text data A2 ...

Is there any way to create a pivot table for data containing alpha characters? I need to create a cross reference table for a 3 column list of data with...

Good Morning Group, I am a Commercial Real Estate Broker and I have several databases with building tenant and owner information that I need to make mailing...

I have an Excel 2002 worksheet connected to a SQL Server 2000 database. The data query is simply: SELECT Count(*) FROM Orders WHERE SALE_DATE= When prompted...