can i load full version of excel on to a ipaq unit
I wonder, does the IPAQ run the full version of Windows?
Rob van Gelder - http://www.vangelder.co.nz/excel
"ej" <firstname.lastname@example.org> wrote in message
No. You are limited to Pocket Excel.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"ej" <email@example.com> wrote in message
Yeah, and that's terrible too.........I also would like a pocke...Can not save modification of subject in mail on outlook 2003
When i try to change the subject and save it on of either mail on outlook
2003,it's error warning as the mentioned "The item could not be saved because
it has been changed by another user or in another window.Do you want to make
a copy in the default folder for the item?".And,that's remind me with the two
choices of "Yes" or "No".
If i press the "Yes" button,it will new another item on outlook as just
modification,BUT,the original item of mail is still existing on outlook.If I
press the "No" button,it will be canc...Can you use multiple vlookup's to generate one answer?
I need to look up 3 different matches to generate an answer, and I was unsure of how to do this?
As an example. I need it to match the piece of fruit, the state it was grown in, and the season, and then for it to return to me who the seller is.
In the spreadsheet there are multiple variations of these combinations.
Can this be done, what would the formula look like?
EggHeadCafe - Software Developer Portal of Choice
Exchange UserCredential between client and webservice in.NET
http://www.eggheadcafe.com/tutorials/aspnet/5cbf012c-41f8-4133-a6bf-e3a718f0d96f/exchange-usercredential-b...Can't send emails out of Outlook 2003
I just purchased a new laptop and Office 2003.
I can receive emails but can't send out. I called Tech24
earlier today- who temporarily fixed the problem (or just
lucked out messing with settings) but it's not working
again. The settings are correct (I called my ISP).
Any suggestions are welcome.
If you use the Test Account Settings, what error message(s) do you get?
Please post the exact text.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account ...Customization Certification
a. Can I take CRM Customization Certification Exam if I am not
employeed by MBS partner organization?
b. Can any VUE/Promotic test centers arrange the test? -OR- MBS exam
needs special arrangements, e.g. MBS partner organization code/
Thanks in advance.
yes you can take the exam, as long as you pay :)
VUE/Prometric will arrange the test for you, just contact their affiliated
exam center near to you :)
<firstname.lastname@example.org> wrote in message
> a. Can I take CRM Customization Certification Exam if...Drop down list 04-04-10
I have a drop down list with names in it. I need the names to disappear as
they are being selected when you go down to the next row, so when you get to
the last row there should only be one name left. Thanks.
Take a look at this article from Debra Dalgleish's site:
Hope this helps.
On Apr 4, 1:50=A0am, Lost Cluster
> I have a drop down list with names in it. I need the names to disappear a=
> they are being selected when you go down to the next row, so wh...Linking Lists and Filters between Worksheets in Excel
Hello, I have two worksheets in this workbook. One worksheet has the names of
students that I have, what classses they are in, and their contact
information. The second worksheet has the names of the students that I have,
the tests they took, and all the answers they gave for each test.
A Hypothetical Example:
Jerry Economics Classroom #104
Jimmy Finance Classroom #104
Natalie Economics Classroom #334
Amy Finance Classroom #104
Jerry...can i print the training presentations?
Can someone tell me how to print the pages of the training courses like excel??
When i used print all it did was print the top and last line on eacg page
but not the info in between?? Is it possible to print it??
...Can there be a header on the first page, but not on the subsequen.
I need to connect several sheets together lengthwise, so I don't want the
footer on all the sheets. Is there a way to have it on one sheet, but not
the others? Is it possible to have it only on the third sheet, for instance?
Print those sheets separately & change the page setups.
"glaserk" <email@example.com> wrote in message
> I need to connect several sheets together lengthwise, so I don't want the
> footer on all the sheets. Is there a way to have it on one s...row and col ref are all num how can I get it back to letters?
in excel 2007 my column and row references are all numbers all of a sudden.
How can I get the column references back to letters?
To turn R1C1 referencing on or off in Excel 2007:
1. Click the Office Button.
2. Click Excel Options.
3. Switch to the Formulas tab.
4. Click the R1C1 reference style check box. A filled box will enable R1C1,
a cleared box will disable it.
5. Click OK.
> in excel 2007 my column and row references are all numbers all of a sudden.
> How can I get the column references back to letters?
...how can I view Tabs on the screen
I have turned on View | Special Characters. Everything else shows, but the
tabs do not. Any ideas on what may have turned them off?
> I have turned on View | Special Characters. Everything else shows,
> but the tabs do not. Any ideas on what may have turned them off?
> Thank you.
Just to clarify...what are you referring to as "tabs"?
Also which version of Publisher are you using?
MS Picture It! -
Digital Image MVP
Highlights and FAQs
http://tinyurl.com/ac...how can you print only odd or even pages on a DJ 1220c
I know I did it before and know I can't find it. I am trying to print on
both sides of the paper by printing first odds and then even pages. I am
using excel 2000 in windows xp
Use this macro
Regards Ron de Bruin
"Curtisgriffin" <Curtisgriffin@discussions.microsoft.com> wrote in message
>I know I did it before and know I can't find it. I am trying to print on
> both sides of the paper by printing first odds an...count with data filters on
Is there a way in Excel 2003 to use one of the count functions on a sheet
that is using data filters. If I filter a column so that, for example, 10
rows out of a total of 100 rows are currently displayed, to use a counta or
countif function to count the rows filtered? In other words, I want the
count function to return 10, not 100...thanks in advance for your help!
Try using the SUBTOTAL function.
The value returned is dependent upon the first argument (parameter)
in the function.
=SUBTOTAL(9,A2:A100) returns the sum of visible numbers in a filtered range.
Here are other 1st ...Date Format Problem
I am using Windows XP/Office 2003 and have the following problems:
I am making an attendance sheet where in Cell C4 is having value
(01/09/2005) showing Sep-2005 (formatted as mm-yyyy)
>From A5 downwards I wish to have the following
A5 : 9-1 Thursday
A6 : 9-2 Friday
A7 : 9-3 Saturday
I have entered the following formula in A5
=MONTH(C4)&-DAY(C4)&TEXT(C4,"DDDD") which gives me the desired result
My problem is when I drag it down it shows me values which I don't
want...How can I drag and just have Day and the Weekday incremented as
foll...conditional formatting of a percent
I would like to use Conditional formatting on a percent field that is
calculated in my report. The text box field contains the formula
=[TotNot]/[TotEmp]. This field displays a percent on my report. I would
like to Highlight and Bold the percent if the field is greater then 50%. I
have had no luck with the things I have tried. Any suggestions?
Using Conditional Formatting on the Format menu (in report design view), set
Condition 1 to:
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to ...In excel can you randomly select lines from another tab to post?
I am looking for a way to randomly select lines from a list of items for
work. Is there a way to perform this function in excel?
Lets say you have a list of 15 items.
Pressing F9 will generate a new random value from your list. Note that
RANDBETWEEN requires the Analysis ToolPak add-in.
*Remember to click "yes" if this post helped you!*
> I am looking for a way to randomly select lines from a list of items for
> work. Is there a way to perform this function in excel?
...Copying conditional formats
I can't find anything in help about copying conditional formats to other
cells - very frustrated. Help infers that the Format Painter can be used,
but that copies all formatting (color, lines, etcetera). How do we just
copy the conditional format and none of the other formatting attributes?
Why can't we simply apply one of the existing conditional formatting rules
from the conditional format menu?
copy the cell | go to edit | paste special | format | ok
On Nov 23, 3:55=A0pm, "Blue Max" <mailrich...@msn.com> wrote:
> I can't find anything in help about ...Conditional Formats #2
I have to somehow apply a compound conditional format to a worksheet that is
only partially shown below. Here is my requirements which are difficult to
The correct answers to a multiple choice test are shown in row 2, columns
Students were asked to gauge their confidence in their answers, on a scale
from 1-3 which are shown in C,E,G,I
I need to conditionally format the answers so that they are Bold Italics if
the correct answer appears and color code the cells with the answers
depending upon the confidence level (on color for a 1, another for 2, and a
third for a 3).
...Putting a logo into a Custom Header
I am using Excel 2000. I have to create a header, with a company address on
the left, and its logo on the right. I have tried pasting it in, and
nothing seems to work. Any suggestions? Thanks in advance.
> I am using Excel 2000. I have to create a header, with a company address on
> the left, and its logo on the right. I have tried pasting it in, and
> nothing seems to work. Any suggestions? Thanks in advance.
...Date format #33
I want to have a column to be my date field. I want to be able to enter for
instance 09072005 or 90705 I would like for Excel to be able to convert it to
read 09/07/2005. If I format my cell to Date it reads as ########, If I
leave my cell as General it excepts the number but does not have the slashes.
Thanks for your help.
On Thu, 8 Sep 2005 10:35:03 -0700, "AG" <AG@discussions.microsoft.com> wrote:
>I want to have a column to be my date field. I want to be able to enter for
>instance 09072005 or 90705 I would like for Excel to be able to convert it t...Help with displya of time formats
I'm trying to add up some times, ie: 00:01:30 + 00:01:40 - adding one minute
and 30 seconds to 1 minute and 40 seconds. I can get the addition to work
properyl and yeild the desired result, however the constant displaying of
full clock time for the above numbers makes it a real pain to edit the
times. Is there a simpler way of displaying time so that there is no date,
or AM or PM or the addition of an hour in front of the number (ie 00:01:30
becomes 12:01:30)? Even if I format the number as mm:ss, I still get the
hour showing when a number is entered.
I was hoping to use Degrees, Minu...Custom Action
Is there a way to set up a rule to mark a message as read
when it is received?
In Outlook 2002, you can set this as part of a rule. For Outlook 2000
or earlier, you would need one of these:
MVP - Outlook
*** Replies sent to my e-mail address will probably not be answered --
please reply only to the newsgroup to preserve the message thread. ***
"Garth Bender" <firstname.lastname@example.org> wrote in message
> ...CFtpFileFind::FindNextFile() can't get the correct file name. #2
Once I want to get file from HP-UX by FTP. I use MFC
CFtpFileFind to find the files under a specified directory
in HP-UX, but the return value of CFtpFileFind::GetFileName
() is not the correct file name, it includes time
(sometimes and date) ahead, such as:
but the real file name existed are only Mydemofile001.txt
Is there any problem in the low level encapsulated by MFC
for FTP list files? Could anyone give me some advice?
...Loading Customers with Purchase History
Hi All ~
I've accumulated quite a few customer names, some with the date and
purchase amount, in Excel.
How would I go about loading this data into the database?
Is there a child table to the customer table that contains purchase
history? I'm not finding one.
Your help would be appreciated.
Purchase history is in the transaction table - each transaction may be
linked to a customer. You do not want to import this data as transactions -
you might consider loading it as text into the Customer.Notes field though.
Tiber Creek Consulting
http://www.ti...Customer NOTES field in Additional tab?
does anyone know why the NOTES field is so small? Is there anyway to change
that? We take a lot of notes on our customers and it's so inconvenient that
this field is so small.
Just keep typing, its unlimited length.
"Zorian" <Zorian@discussions.microsoft.com> wrote in message
> does anyone know why the NOTES field is so small? Is there anyway to
> that? We take a lot of notes on our customers and it's so inconvenient
> this f...