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 » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 14 of 14
Search took 0.10 seconds.
Search: Posts made by: Gandor
Forum: Using Forms June 7th, 2010, 09:07 PM Posted to microsoft.public.access.forms
Replies: 0
Views: 1,896
Posted By Gandor
How do I control a text box via another combo box

I have read through dsome o the other answers and I just can't seem to get it.

I have a table called employee information.

Within that table are two fields. Retail Title and Retail Incentive.

I...
Forum: General Discussion February 25th, 2010, 07:19 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 94
Posted By Gandor
Vlookups and formats

Thanks Dave that was what I was looking for. I was thinking to complex and
just needed another look. Thanks Again.

"Dave Peterson" wrote:

You could also use:
=1*(mid(...))
or
...
Forum: General Discussion February 24th, 2010, 10:14 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 94
Posted By Gandor
Vlookups and formats

I am using the following formula to pull in the worksheet name into cell B5

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

The worksheet name is an account number.

I then use...
Forum: General Discussion January 6th, 2010, 08:46 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 79
Posted By Gandor
Repeat Rows at Top - Except Final Page

Is it possible to repeat rows at the top of each page, but not for the Final
Page?

For instance I repeat rows 1 and 2 and have page breaks for a total of seven
pages. I want the repeated rows on...
Forum: General Discussion December 16th, 2008, 01:51 PM Posted to microsoft.public.excel.misc
Replies: 4
Views: 52
Posted By Gandor
Format cell to the nearest 100

Thanks for the suggestions. I was hoping for a format versus a formula. But
this will do

"TKS_Mark" wrote:

Gandor: Try =ROUND(A1,-2) where A1 is the number you want to round.

"Gandor"...
Forum: General Discussion December 15th, 2008, 09:57 PM Posted to microsoft.public.excel.misc
Replies: 4
Views: 52
Posted By Gandor
Format cell to the nearest 100

Is there a format for rounding a cell to the nearest 100 so that 501.35
rounds to 500. I was using #,##0 to just round to the dollar, but I want to
got to the nearest 100.

Any thoughts?
Forum: New Users July 29th, 2007, 10:46 AM Posted to microsoft.public.word.newusers
Replies: 7
Views: 81
Posted By Gandor
Disk failure, need to recover lost doc

Hi!

I thought so. I just hoped for some magic. Thanks for answering.

Gandor

"Graham Mayor" wrote:

The document is corrupt. You cannot somehow magic the missing data back into
existence.
Forum: General Discussion July 27th, 2007, 11:30 PM Posted to microsoft.public.access
Replies: 5
Views: 35
Posted By Gandor
In need of instant help

Thanks for your answer. How stupid of me. I'm new on this, first time using
this service. I'll try to find help in Word newsgroup. But I think I'm out of
luck and it sucks.

Winston wrote:

On...
Forum: New Users July 27th, 2007, 11:16 PM Posted to microsoft.public.word.newusers
Replies: 7
Views: 81
Posted By Gandor
Disk failure, need to recover lost doc

I was writing in a word document that I had saved in a USB memory. I had
nothing saved at the hard drive, stupidly me. Suddenly it crashed and the
document weren't to be found on the USB memory...
Forum: General Discussion July 26th, 2007, 08:22 AM Posted to microsoft.public.access
Replies: 5
Views: 35
Posted By Gandor
In need of instant help

Hi,

Thanks for writing, but I need need to know if I can read this rescue
txt.document. The thing is that I had just only used the USB memory, which
was very stupid of me. I am new with computers...
Forum: General Discussion July 26th, 2007, 03:36 AM Posted to microsoft.public.access
Replies: 5
Views: 35
Posted By Gandor
In need of instant help

I was writing in a word document that I had saved in a USB memory. Suddenly
it crashed and the document weren't to be found on the USB memory.I found a
emergency saved notepad.txt.file copy on my...
Forum: General Discussion May 10th, 2007, 10:26 PM Posted to microsoft.public.word.docmanagement
Replies: 0
Views: 53
Posted By Gandor
Windows mail

After I have installed office xp prof in Windows Vista, I alwyas recieve
messege that "Windows Mail started up wrong" and therefore "Windows Mail
program has to be stopped" when I starts up my...
Forum: General Discussion May 9th, 2007, 09:46 PM Posted to microsoft.public.word.docmanagement
Replies: 1
Views: 43
Posted By Gandor
Can I use office XP prof with windows Vista

My old notebook dropped dead and I had office XP (word 2002?) professional
installed on that computer with window XP as operative system. I have now
bought a new notebook with windows Vista as...
Forum: General Discussion May 7th, 2007, 10:09 PM Posted to microsoft.public.word.docmanagement
Replies: 1
Views: 55
Posted By Gandor
Showing results 1 to 14 of 14

 
Forum Jump

All times are GMT +1. The time now is 12:10 PM.


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