A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Display standard time without "AM or PM" while entering in military time by 23shun
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...
July 22nd, 2004 12:48 AM
by Dave Peterson Go to last post
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 Go to last post
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...
July 22nd, 2004 12:23 AM
by Dave Peterson Go to last post
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.
July 22nd, 2004 12:21 AM
by unlikeKansas Go to last post
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 Go to last post
6 184
Excel - "window option" items in Tools/Options were dim - how torecover ??? by Dave Peterson
First, I don't think I've ever seen this. Does it happen with all workbooks or just a certain one? If you start excel in safe mode, does that work? Close...
July 22nd, 2004 12:01 AM
by Dave Peterson Go to last post
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...
July 21st, 2004 11:46 PM
by Dave Peterson Go to last post
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...
July 21st, 2004 11:29 PM
by unlikeKansas Go to last post
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...
July 21st, 2004 11:27 PM
by Frank Kabel Go to last post
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...
July 21st, 2004 10:48 PM
by Frank Kabel Go to last post
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...
July 21st, 2004 10:46 PM
by Myrna Larson Go to last post
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...
July 21st, 2004 10:44 PM
by Myrna Larson Go to last post
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...
July 21st, 2004 10:17 PM
by Ron Rosenfeld Go to last post
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 Go to last post
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/
July 21st, 2004 08:47 PM
by Frank Kabel Go to last post
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...
July 21st, 2004 08:30 PM
by Jean Larson Go to last post
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...
July 21st, 2004 08:00 PM
by Ron Rosenfeld Go to last post
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 Go to last post
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...
July 21st, 2004 07:50 PM
by Ron Rosenfeld Go to last post
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...
July 21st, 2004 07:27 PM
by Frank Kabel Go to last post
1 293
Post New Thread


Display Options
Showing threads 137961 to 137980 of 139764
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:42 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.