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
need to fix file title in macro by leeners82
I have the following macro created which allows the user select a file from which a worksheet is copied in to the 'report' sheet of the macro-containing file. ...
June 15th, 2004 11:02 PM
by Anders Silven Go to last post
1 435
Formatting to Currency does not get applied by
I have a column of numbers formatted without dollar signs & decimal points: 1234 5678 9100 I want to apply Currency formatting with decimal points. I select...
June 15th, 2004 11:17 PM
by Gord Dibben Go to last post
5 570
Maximize setting when opeing excel by rollingdan
When I open my Excel program my spreadsheet is always less than minimized. Very annoying as I always have to maximize before doing anything. I tried...
June 15th, 2004 11:23 PM
by rollingdan Go to last post
7 463
cell format by Jean
Could I get the correct way to format cells in Excel 97 SR2 to include text and numbers? For example, I need the string L1234567891 to show as L-123-456-7891....
June 15th, 2004 11:42 PM
by Jean Go to last post
2 334
Row Hidden or height set to 0 by CS
The A1 row in my worksheet is not visible and I can't find a way to display it. Following help, I went to Edit/Go To/"A1" then Format/Row/Unhide or Height = 13...
June 15th, 2004 11:44 PM
by CS Go to last post
7 329
Drop downs by Neil R
I have an excel worksheet which contains 3 seperate worksheets into one. I have managed to use the drop down function on the main worksheet from data used on...
June 16th, 2004 12:00 AM
by Gord Dibben Go to last post
2 482
Adding the DAY to a Date field? by Earl Kiosterud
Dave, I couldn't get the Alt-0010 to work. It drops to a second line in the custom format box as you would expect (I have to arrow up and down -- it only...
June 16th, 2004 12:00 AM
by Dave Peterson Go to last post
3 263
Hiding Checkbox from "Forms" Toolbar by bg18461
I have some rows that I want to hide in my spreadsheet, I also have checboxes within those rows to hide. When I hide the rows, the checkboxes remain. I know...
June 16th, 2004 12:05 AM
by Dave Peterson Go to last post
6 550
Macro needed? by Continental Translations
I am after something which will delete excess spaces in certain cells. In some of my cells, I have a couple of words. Some of these words however have 2 spaces...
June 16th, 2004 12:21 AM
by Dave Peterson Go to last post
8 323
email attachment by rgm
I have been sent email attachment with .xls extension. I do not have excell on my computer. Is there a way to open the attachment? Thanks for your help.
June 16th, 2004 12:42 AM
by Norman Harker Go to last post
1 265
Code to read a cell from every workbook in a folder by dovrox
Any Ideas about what code would read the formula in cell c3 of every workbook in a folder and give an array of the workbook names and...
June 16th, 2004 12:45 AM
by Dave Peterson Go to last post
1 395
create datevalue yyywwd by jocke
is there any way to create the datevalue yyyywwd (year, weeknr, day of week) from today's date? in vba code or/and in a spreadsheet tia /jocke --- Message...
June 16th, 2004 12:47 AM
by Dave Peterson Go to last post
2 331
choosing from drop down lists easily by Dave W
I have several lists that appear as a result of selections from other list through data validation. Is there a way to go right to say ..all the words...
June 16th, 2004 12:49 AM
by Anne Troy Go to last post
1 276
Calendar Mail Merge?? by JMax
Good Afternoon, I have a fairly simple spreadsheet with less than 10 columns. Each item (row) contains 3 dates, Open Date , Close Date and Live Event. Is it...
June 16th, 2004 12:51 AM
by Anne Troy Go to last post
1 330
Custom Fill Colors Issues by G. Sesame
Hello. I have saved three custom colors in my fill color box. Whenever I send a file containing these custom colors to another user, the user doesn't see the...
June 16th, 2004 12:54 AM
by Dave Peterson Go to last post
3 526
TextToColumns question by Arch
I want to split full name column into three columns, first, middle, last. Some of my full names do not have middle initials. In that scenario, the last name...
June 16th, 2004 01:12 AM
by Don Guillett Go to last post
2 187
Copy & Paste sections of data by Christine Wilso
I receive data each day exported into an excel file. In column A there is a list of Areas, in column B a list of months from April to whatever the month we are...
June 16th, 2004 01:36 AM
by Dave Peterson Go to last post
1 309
Excel Manual Calculation is stubborn by Hari
Hi, I set my Excel options -- calculation to manual because I have one very heavy sheet.Last 3 weeks or so I didnt change the option. Now, I want to change...
June 16th, 2004 01:55 AM
by Dave Peterson Go to last post
7 622
Calcuating % of increase - negative amts by Mark
I am trying to calculate the % of increase in revenue from one year to the next. If Cell A2 (2003) is $100.00 If Cell A3 (2004)is $500.00 % of Increase in...
June 16th, 2004 02:16 AM
by Ron Rosenfeld Go to last post
5 403
palindromes by thank you
Looking for palindromes solution. Something that would print number of steps and the end result when a number entered in cell A1. Thank you!
June 16th, 2004 03:15 AM
by Ron Rosenfeld Go to last post
1 188
Post New Thread


Display Options
Showing threads 201 to 220 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 06:21 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.