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
"Watermark" in Excel by H Chan
In Word, I know how to do a watermark background. How do I do this in Excel? For example, I would like to see the word "Draft" as background text. Is...
August 21st, 2004 09:52 AM
by Frank Kabel Go to last post
1 198
Variable File Naming Using Macros by Kris S
Is there a way to open a file and rename it using cells within the document itself using a macro? (Variable File Name?) Also, is there a way to open a file,...
August 21st, 2004 08:36 AM
by Frank Kabel Go to last post
1 145
Losing data when saving as a dBASE file by JTM
Even though data (the cell in question is a zip field that I have formatted to display the leading zero) is displayed in cells of my active worksheet, when I...
August 21st, 2004 07:41 AM
by 43N79W Go to last post
1 281
Multiple SQL Queries on one sheet by Kevin
I am editing the last SQL query on a sheet that has 5 queries on it. I am adding a column. Excel is insisting on shifting columns for the queries above over,...
August 21st, 2004 03:03 AM
by Kevin Go to last post
2 609
Matching values in 2 Columns by Portuga
Hello, In Column A I have a list of unique case Numbers. (around 3000) A1 123456 A2 234567 A3 345678 In Colums B I have a list of unique case Numbers...
August 21st, 2004 02:45 AM
by Soo Cheon Jheong Go to last post
2 303
Column to Text Question - Stop after one break by Sole Admiral
I am stuck on a text - Column issue. This feature is wonderful and has saved me hours of work, but i was wondering if there was a way to just seperate the...
August 21st, 2004 02:31 AM
by Erin Go to last post
1 308
August 21st, 2004 01:27 AM
by Debra Dalgleish Go to last post
1 174
Moving Columns to Rows by David Patterson
Is there any easy way I can achieve the following without a very laborious route of manually copying and pasting loads of data? I have a large spreadsheet of...
August 21st, 2004 12:12 AM
by Debra Dalgleish Go to last post
7 259
Sortng Custom Views by TONYC
I have been saving filtered criteria using 'custom views', icon on the toolbar, however, as this list grows, I would like to sort the assigned names in...
August 20th, 2004 10:48 PM
by Debra Dalgleish Go to last post
1 296
Retaining highlighting when focus changes by Bill Sutton
I am using Excel 2003. I have a spreadsheet full of data open; I find and select the cell or row containing the data I need and that cell or row is...
August 20th, 2004 10:08 PM
by Dave Peterson Go to last post
1 265
Copy Paste turns numeric string into Scientific Notation by David
Thanks for the quick reply, Unfortunately, whatever technique is used has to be explained to all users that need it. I can't identify the columns beforehand,...
August 20th, 2004 10:04 PM
by AlfD Go to last post
3 386
Date problem by Gerry
I have a column containing 4/21/2004 10/7/2003 5/5/2004 Which I need to convert to UK dates. because of the variables(4/, 10/) I am unable to use mid etc in...
August 20th, 2004 09:10 PM
by Dave Peterson Go to last post
3 158
Adding a ' to the front of a column of numbers by punter
Hello everyone, I have two columns of numbers in excess of 35,000 lines. I need to do a look up from to the other. The problem I'm running into is that...
August 20th, 2004 08:43 PM
by Gord Dibben Go to last post
4 375
Zipping Excel files by Brian
If I zip up an Excel file of 7,115,716 bytes, the resulting zip file is 1,206,499 bytes, a reduction of 83%. If I do the same with an Excel file of 25,063,936...
August 20th, 2004 08:40 PM
by Gord Dibben Go to last post
4 243
copy from 150 diff xls files and combine into one by Shaun
Hello, I have 150 .xls files each containing over 500 rows of reports. I need to copy about 30 rows from the middle of each file and combine into one file. ...
August 20th, 2004 08:39 PM
by Ron de Bruin Go to last post
3 365
protect document by Neil Greenough
How do I protect a document, so that when I email somebody an invoice for example, they cannot change any of the information on it? Also, I have a column of...
August 20th, 2004 08:34 PM
by Gord Dibben Go to last post
4 310
Hiding sheets based on user by James
Is there a way to create conditional workbook and worksheet views based on the value of a particular cell? Below is what I'm trying to accomplish: I'm...
August 20th, 2004 07:56 PM
by icestationzbra Go to last post
3 343
Extract SSN's from a free form text field... by Viv
I am trying to extract SSN's from a free form text field where the SSN may appear in any portion of the field (beginning, end or middle of the field). The SSN...
August 20th, 2004 07:38 PM
by Biff Go to last post
3 404
why is this happening, how do I fix it? by KEL KEl
Everytime I enter "1996" in an excell cell, and it doesn't mater if there are other characters around it ie. *1996* as soon as I tab out or "enter" the 1996...
August 20th, 2004 07:29 PM
by KEL KEl Go to last post
2 230
Column numbers to letters by Martha
In excel, how can I change the column titles from numbers back to the usual letter?
August 20th, 2004 07:19 PM
by Go to last post
3 364
Post New Thread


Display Options
Showing threads 136761 to 136780 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 07:20 AM.


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