Custom Number Format for Weight
I have a formula that I would like to display the result as pounds and
ounces. I created and custom format that will display as (for example) "14.25
lbs" but I would like it to display as 14 lbs 4 oz. It must display as a
number and not text. Any help would be great!
No can do with a format, methinks. How about displaying pounds and ounces
in another cell (column)?
=INT(A2) & " lbs " & MOD(A2,1)*16 & " oz"
This yields a text string, so you can't do any math on it; use the original
(A2) cell for that.
the first time i come here,i am even donot know what topic can talk in
Best Regards & Thanks
...Automatically Import Data to 4.0
I was wondering if there is a way to automatically import data into CRM 4.0.
Possibly have it monitor a director that contains a csv file and have it
automatically update/upload the contents into CRM?
Thanks for the help!
It is import Tool, you can make windows service and schedule it using your
MS CRM Certified Professional...Report 03-30-07
I am having troubles when I run a Report I have it set to ask who to Bill To.
Instead of typing the whole address is there a way I can just type the name
of the company and in the report it will put the Name and address of the
Message posted via AccessMonster.com
Sure. In your query (upon which the report is based) just put criteria
under the company name field. In that criteria put something like..
Like "*" & [Enter Partial Company Name] & "*"
This will cause only the ...IMPORTING ADDRESS BOOK #2
How can I import a address book from Yahoo
>How can I import a address book from Yahoo
>Never done it, but import/export commands are in the file
drop down menu. I use hotmail and it will allow importing
but do not see exporting.
...A short code to convert PPT to JPG files?
I know this should not be hard as we had done it before, but I was
searching for some of the books that I have and Web sites only that I
can't find the code sample. Could anyone please give me some pointers
(like books or Web sites or please post it here) for a short code
sample to convert PPT file into JPG/JPEG files (one JPG image per
slide) jusing VC or MFC? Or even better, maybe there is an open-source
solution for this? We are trying to write an add-on to slice PPT files
into JPG files and then the next step is to integrate our streaming
video with these JPG files with SMIL ...Message Box 12-02-07
On my form "frmExitDate" I have a field called "ExitDate" and a command
button called "cmdCloseExitForm" The Field "frmExitDate" needs to be
completed if a student has left the college.
When the button "cmdCloseExitForm" is clicked I would like a Message Box to
give details about the empty field. i.e. "The Field Exit Date must be
However if the Data entry person has opened this form by accident and the
student has not left the College, I obviously need to be able to close the
form without completing the field....Numbers to text
I am trying to produce (Using Excel 2002 XP) a time
card. I need a day of the week, which I have retrieved
using the WEEKDAY function. That give me the day of the
week in a number. Now I need to convert that number into
the actual day of the week. I've tried using a nested
function first for the weekday and then VLOOKUP to
convert that number to an actual day of the week, but I
have not been successful.
Is there an easier way?
HTH. Best wishes Harald
Followup to newsgroup only please.
"Lorrie" <email@example.com> wrot...Parameter Query Problem 12-21-07
Hi, I'm creating a Paramater Query based on the date of a payment and receipt
number for a record which includes 1st payment, second payment, and 3rd
payment and 1st receipt number, 2nd receipt number, and 3rd receipt number
fields. How do I retrieve only the field results which match the parameter
criteria without pulling up other field values of that record which may not
fit the search criteria? Thank you for any suggestions.
I suggest that you change you table structure to something like this ---
PayID - autonumber
Invoice - (could be SalesID - relates to sale &...Delete Query 03-29-07
Hi, this is my problem:I need to delete from table "A", all fields that exist in table "B"I tried a "delete query" but it sends an error "Please specify the tablewhere you want to delete the records" (its translate from spanish)What Im doing wrong....???...Why won't the number 9 enter as that and gets replaced with 0 ins
I am entering9 to 16 digit actual account numbers and every time I use a 9 it
gets replaced with a 0. WHY? and what do I have to do to get it be what I
Excel's precision is 15 significant digits.
Numbers that are actually identifiers can be entered as text. Either format
the cell as text before entering the number or precede the number with an
apostrophe, which will not show
"Lorissa" <Lorissa@discussions.microsoft.com> wrote in message
>I am entering9 to 16 digit ...Importing .Wab (Adress-files) tol Outlook how do I do that?
I have just become member of a amature theatergroup, and=20
will like to import there . WAB - Mail-adresselist into my=20
2000 maillist. Acording to Outlook help you schould do the=20
1: Click on functions
2: Find Adressebook, click on it
3: Find Files, click on it
4: Find Import, click on it
Here comes the trouble... my Import and Export submenus=20
stays gray and inoperativ...what do I do - how do I import=20
a .WAB Adresse file....
Sorry I am Danish and my spelling is=B4ent that=20
perfekt...hope you get the point in my quistion...!
Outlook cannot imp...Importing Money files
I just purchased MS Money 2004 and wanted to import my
existing files on MS Money 3.0. Having trouble doing
this. Have any suggestions?
One suggestion: you throw us some bones as to what you've tried and why it
isn't working (error messages, etc.) We try to help where we can, but this
"Steve M" <firstname.lastname@example.org> wrote in message
> I just purchased MS Money 2004 and wanted to import my
> existing files on MS ...Error on importing customization
I'm getting an error when I try to import a cutomizatin XML file from a
server to another server: "The file cannot be upload or it is not a valid
The only difference between the 2 servers is that one is SQL 2000 and the
other is SQL 2005.
What can I do ?
You may want to look at this KB and if it does not answer your problem
please copy and paste (or type) the exact error message back.
"Jau" <Jau@discussions.microsoft.com> wrote in message
news:288D88FD-FC11-49...How to add hyperlink in a same PPT
I have one big PPT file contain more then 30 slids, I want to make hyperlink
with in the same PPT. but the trick is I want to link with few continuous
pages and then again wanted to come up on the same page from where i have
started the hyper link.
1) suppose I have a PPT of 10 slides.
2) I put hyper link on slide number 2 and link to slide 4
3) now when i reached to slide 4 then i will go to slide 5 but after this it
should not allow me to go to slide 6 th
i want that it should only send me back to slide 2nd . no other slide can be
accessible from sl...Inbound Email 01-15-07
I have created an Auto-Reply rule from when cases get created. If a
user eplies to the email, I would like it to get recorded back into the
CRM, I beleieve this is possible.
As there any configurations that need to happen to do this? When I
reply it goes to the case owner like a normal email but does not go to
the CRM as well.
Not my strongest area of CRM but I believe you need a rule that forwards your
mail to the CRM Mailbox.
MCDBA 2000 | MCITP DBA 2005
> I have created an Auto-Rep...Number of copies when printing
Can anybody help...?
We are currently printing off a form that has been duplicated many
times to obtain answers to many questions in a way of collecting
The problem is that whenever we print the form with the answers, the
default setting is 10 copies.
This is not the default setting on the printer and all other documents
from word, outlook etc, print just one copy. Is there a setting
somewhere within the excel file that is forcing the 10 copies...?
We did not generate the form originally and the company who did are
unable to answer our question.
Any help would be app...Nz Function 10-08-07
I am using the Nz Function it work fine but my Currency is now gone how can i
get the currency format to return?
SELECT qrySubCost.Division, qrySubCost.Carrier,
Nz([Cumulative_Impact],"N/A") AS CumulativeImpact
Are you using this query as the record source for a form or a report? If
yes, you can set the Format property of the control that is bound to the
CumulativeImpact field -- however, note that you're putting a text string
("N/A") into a format for currency .....
<MS ACCESS MVP>
"Octet32" <O...Re: The Annoyance Of Having To Click Twice 06-07-10
> (64 bit)
> "C:\Program Files (x86)\Windows Live\Mail\wlmail.exe" /news
I don't have any such file in Windows Ultimate to create the shortcut to.
Only -- C:\Program Files (x86)\Windows Live\Mail\wlmail.exe
Which opens on EMAIL.
"Nancy Jackman" <email@example.com> wrote in message news:...
> 1. Create that shortcut to:
>> (64 bit)
>> "C:\Program Files (x86)\Windows Live\Mail\wlmail.exe" /news
> 2. Place it on the desktop and/or in Start.
> 3. Then click on one of those?
&...How do I do an outstanding check import for first bank reconciliation
What are the steps that need to be taken within GP to import outstanding checks? I have already written the integration, but cannot recall the process. Amywhetzel,
Are you running Integration Manager to import Bank Transactions? If so, the
destination should be Bank Transaction Entry. You will want to be sure you
don't post through GL or it will decrease your GL cash balance. Remember to
enter your last bank balance per your statement into the Checkbook
Maintenance window before you run your first reconciliation. Also, if any
subledger transactions have been done after Bank R...Concatenate text & number cell
I need to concatenate a word and a number cell. eg,
Concatenate("Limit = $",A1) where A1 = $100,000. It shows
up like this: "Limit = $100000". However I want the
number to format with the comma between the thousand,
ie. "Limit = $100,000"
Does any one know how to do this. Thanks in advance.
="Limit = " & TEXT(A1,"$#,##0")
In article <firstname.lastname@example.org>,
"John" <email@example.com> wrote:
> Hi all,
> I need to concatenate a wo...Importing from pdf possible?
I have an acrobat pdf file that has the appearance of a table of data.
Is there any utility that attempts to import this into Excel 2002?
Obviously it would have to use some sort of intelligence and the result
would need careful checking.
Return email address is not as DEEP as it appears
You can convert the pdf to an html file, and then open it
up in Excel. Of course you'll lose some formatting but you
can reconstruct it with copy/paste or some formulas.
You need to download pdf995 to start the process:
>-----Original Messa...Import multiple share price
Does any one know how to import multiple share price
updates in text (comma separated) format (eg date,share
code,price) into Money 2004 similar to the "import prices"
function in Quicken?
"Ian" <firstname.lastname@example.org> wrote in message
> Does any one know how to import multiple share price
> updates in text (comma separated) format (eg date,share
> code,price) into Money 2004 similar to the "import prices"
> function in Quicken?
test This is the body of the article
...Importing of files
My computer crashes and I have to install all my OS and
software again. All my previous message in the outlook
cannot be import back. I back up only the dbx files and
did not do any export of message. Is this why I cannot
import my message back? I am using outlook 2002
If you're using dbx files, you are not using Outlook
"Ian" <email@example.com> wrote in message
> My computer crashes and I have to install all my OS and
> software again. All my previous message in the outlook
> cannot be import back. I back up ...