How do I make numbers become text?
I am trying to create a spreadsheet where numbers entered in one location
become text in another. I tried the Help option, but I am still lost. Please
help, and thank you.
From earlier postings:
How to Convert a Numeric Value into English Words
(courtesy of a cut and paste from a Tom Ogilvy post):
If you want an addin that provides a worksheet function
download Laurent Longre's free morefunc.xll addin found
It is downloaded in a zip file which also conta...No message in outbox
I tried to send a message with 1Mb attachment to 40 recipients in the bcc
field. It gave me an error message from the isp's server, the message was
NOT sent (I've checked), it did NOT arrive in Sent Items, but neither is it
in the Outbox any more. I can send and receive email successfully.
Problem is, every few minutes Outlook tells me it's sending message 1 of 1,
it fails and gives me the same error message. Yet there is no message in
the Outbox. But what happened to the original message when it first failed
to send? I guess it's 'stuck' somewhere but I can...Sending mail from selected email address
As I have 4 email accounts set up in Outlook, I understand that I can send
mail from each or any account.
The accounts are listed under tools / Send and Receive / then each of the
How can I choose which account to send from so that the recipient see's who
I want it to be from??
Hope that explains it.
On Sat, 16 Apr 2005 21:10:48 -1000, The Fatman <firstname.lastname@example.org>
> Hi All,
> As I have 4 email accounts set up in Outlook, I understand that I can
> mail from each or any account.
> The acco...Can I get a picture to flow with the text?
I want a picture box to flow with my text instead of the text flowing around
my picture. Please help!
Position the image in the text box, right-click the image, click format picture,
layout tab, select inline on the drop down. The image has to be fully or
partially in the text box for the inline to be active.
"lnewhall" <email@example.com> wrote in message
>I want a picture box to flow with my text instead of the text flowing around
> my picture. Ple...text extract
How do i extract a variable length string of text from a longer string? My
cell reads "Login LDAP user mapatron at 192.168.1.146 as role student", and
would like to extract "mapatron" from this string. this username is variable
in length, so using three columns and "=right(X,X)" and "=left(X,X)" doesn't
work. any suggestions? Thanks in advance for your help.
any logic WHERE this username is lcated. e.g. always after the string
"John S" <John S@discu...How do I send copies emails without sending attachments?
I send emails with attachments to our bank. My boss wants a copy of the
email but not a copy of the attachment. How do I do that?
Steve Bramblett wrote:
> I send emails with attachments to our bank. My boss wants a copy of the
> email but not a copy of the attachment. How do I do that?
Each recipient gets the SAME copy of the e-mail. If you want different
recipients to get different versions of your e-mail, you have to send
...Sending a macro to another PC-how?
How do you send a macro you've written to another PC so
that they can save it in their Personal.xls file (at
Program Files\Microsoft Office\Office\XLStart)?
You can export a macro and save it, to do this from your workbook,
right-click the workbook's icon and pick View Code. This icon is to the left
of the "File" menu this will open the VBA editor, click on the module you
want to save and go to file and export file, then save it to a floppy or
what ever you backup to, then import it to the new workbook.
Always backup your data before trying something new
Using ...Sending mail from remote location
my mail works great while at home. when I go on the road I can receive
ail but not send. I get the following error message:
Subject 'SKIDOO MACH Z 800LT (long track / long tunnel) (Jackson)',
Account: 'Jeff', Server: 'smtp.charter.net', Protocol: SMTP, Server Response:
'571 imp11 smtp.charter.net OTcuMTQ3LjE2LjIzMA== You must connect from
Charter IP space. E1110', Port: 25, Secure(SSL): No, Server Error: 571,
Error Number: 0x800CCC61
It worked on my last laptop and I have not been able to figure it out on
this one. I can't remember what I...Send and Recieve Fix
For a long time I had a problem with my Send/Recieve function in Outlook.
This happended in both Outlook 2000 and my current version - 2007.
I found I had to re-boot my computer to perform a Send/Recieve in Outlook.
Otherwise the sequence would start then stop and say it could not perform
due to an error.
After extensive Internet and News Group research I decided it was time to
run a check on disk errors.
This Windows XP facility seemed to have fixed my Outlook problem.
I did this about a few months ago now and I have since had no problems with
my send and recieve.
Unfortunately I do have ...anchor picture to text box
(Publisher 2003) I have a newsletter with a Kudos box. In the corners of
the box I have a happy face. I'd like the happy faces to be anchored to
their corners so when I enlarge or shorten the box, the faces move along with
the text box.
Why not create a rectangle, insert the happy faces, group. The problem as I see
it would be if you resize, the happy faces could be distorted if you widen or
shrink the group. You would always have to re-size proportionally.
"Helen" <Helen@discussions.microsoft.com> wrote in message
news:193...Publisher insert picture help
Hi, I'm sure this is a very basic question, but when I insert a jpeg, it
appears black and I can't get the image to appear. There must be something
basic I am forgetting. Please help! Thanks.
Lori H wrote:
> Hi, I'm sure this is a very basic question, but when I insert a jpeg,
> it appears black and I can't get the image to appear. There must be
> something basic I am forgetting. Please help! Thanks.
Maybe you need to update your video driver.
Q: Why can I not see images/shapes/
lines when editing my publication?
http://ed.mvps.o...Unable to send?
I've got MOOL, and i"m usign ti with outlook. The emails that I'm
sending are just "stuck" in the outbox? Can anyone give me an idea of
what's going on?
Did it ever work? Are you able to receive?
Ben M. Schorr, OneNote-MVP
Roland Schorr & Tower
Microsoft OneNote FAQ: http://www.factplace.com/onenotefaq.htm
**I apologize but I am unable to respond to direct requests for assistance.
Please post questions and replies here in the newsgroup. Mahalo!
"Rekks" <firstname.lastname@example.org> wrote ...Logical Test: Text Against Number 12-31-09
Can someone provide some insight into why Excel will always return TRUE when,
for example, we have ="a">27 (or any other number) and FALSE when ="a"<27?
Text has a higher value than a number.
Enter this data:
A1 = a
A2 = 1
A3 = b
A4 = 2
A5 = c
Sort A1:A5 in ascending order and you'll see how Excel orders the text as
being a higher value than the numbers.
Microsoft Excel MVP
"rslaughter5" <email@example.com> wrote in message
news:80AF82FA-D9F8-48A9-9105-059EB3B7E6F0@microsoft...Text in Cell as Formula #3
Peo + Julie Many thanks for your answer with the last query.
I have another similar question; I would like to use values form a
different spreadsheet, and this method [INDIRECT()] fails.
i.e. I type the link (as text) from a different spreadsheet in a cell in the
current spreadsheet and use this method to call a value in a cell.
Appreciate your help.
...Sending messages in Outlook
We have a user that everytime that she sends an email she
will get booted out of Outlook. The email does go
through, but she will have to get out of Outlook. When
she goes back into Outlook, everything is fine until she
sends another message. Any help would be appreciated.
...No Permission to Send/Receive Email???
I just replaced our server hardware, upgraded to WS 2k3
Enterprise and created a new domain. I transferred the
client files and desktop on our desk/laptop computers
over to the new domain. We do NOT have Exchange
installed yet, but use Outlook 2002 with the email etc.
saved on the client.
One one client machine (mine), the email, calendar, etc
are there, but when I hit the Send/Receive button, I get
a message saying that I don't have permission to perform
this operation. Also when I try and change the automatic
check for email option it tells me I don't have
permission. ...Send Do Not Send
When I attempt to email via a print server - OutLook
Express displays the message "A program is attempting to
email on your behalf" Send or Do Not Send - How do you
prevent this from happening? And just automatically send?
...from the text 4 pcs., how to remove only characters/text
Pls help me in the above subject i.e. from the cell contents in excel as "4
Pcs.", what is the formula to be used to remove only number and mention in a
separate cell. i.e. cell should contain only numeric value, not the text.
Chris, is the syntax always the same? i.e. a figure followed by a space
followed by text.
If it isn't, it may be advisable to provide more information on the
possibilities before we get further into it.
"chriswyn" <firstname.lastname@example.org> wrote in message
news:8...appending data from text file with different column orderings
I'm interested in appending data to an Access table without having tobe constrained by the order of the columns in an external file. Forinstance, if I have a table with 4 fields - A, B, C, D - I would liketo be able to have my external file in any column order, say D, C, B,A. Is this possible without programming?>From what I've seen, it seems that I would have to have my externalfile ordered the same as the table - A, B, C, D - and I'd like to haveindependence of the table ordering.Denis On Mar 14, 4:37 pm, John Nurick <j.mapSoN.nur...@dial.pipex.com>wrote:> Hi Denis,...What was Outlook sending?
I downloaded my messages using the option "send and receive all".
However, the "Show Progress" box indicates that I was also 'sending something'.
But I had nothing to send!
I look in the "Sent items' folder and nothing was sent at this time.
What was Outlook 2003 doing?
The usual response here is, "You have a virus". It could
be that a virus program is using your Outlook to send spam
and/or a copy of itself to people in your address book.
I hope this is not the case, but please have the foresight
(aftersight?) to look into ...Picture Manager random captures?
Why does MS Picture Manager capture, apparently randomly, images from the
internet? How can one avoid this unwanted feature?
...Another Accounts Question.
I have an Accounts problem I don't understand and have no clue where to
begin to solve it. I'm using Outlook 2000 from the Microsoft Office Pro
Suite, Internet Only, on XP.
Since I am a Listowner several times over I have fashioned five different
Outlook Accounts to my single broadband ISP e-mail address. All are working
well. My ISP e-mail address is listed as the default. When I send a personal
e-mail I just hit Send and Send and Receive and out my e-mail goes with my
personal address in the header. If I'm sending in the name of a Listgroup I
use Send Using, pick the righ...Sending on behalf... Exchange 2003
Is there a better way to give a few users the ability to send mails also
from the email@example.com mailbox without having them logout and login to a
different Outlook 2003 profile... Or without the text sending on behalf
of... So my question is, Is there an easy way that a user can select another
e-mail address and send mails out...?
Thanks a lot in advance!!
On Thu, 05 Oct 2006 12:57:12 GMT, "BY" <firstname.lastname@example.org> wrote:
>Is there a better way to give a few users the ability to send mails also
>from the info@dom...Outlook Can't Send Messages
This morning I fired up Outlook 2007 (running under Windows 7). It retrieved all
I then tried to post a new email, (not a reply). However, the nano-second that I
clicked on "Send" I received a reply from "System Administrator".
It said this:
Your message did not reach some or all of the intended recipients.
Subject: The Train Meltdown
Sent: 27-Jul-10 1:18 PM
The following recipient(s) cannot be reached:
email@example.com on 27-Jul-10 1:18 PM
None of your e-mail accounts could send to this recipient.
I have 3 active email ac...'SEND' just sends it to the OUTBOX
Outlook 2007 on WinXP Home SP3. When I click 'SEND' when replying to an
email it does not SEND but puts it in the OUTBOX. I have to click
SEND/RECEIVE from the main page to actually SEND the email. Is there a
setting I am missing? Thank you.
"Peter" <firstname.lastname@example.org> wrote in message
> Outlook 2007 on WinXP Home SP3. When I click 'SEND' when replying to an
> email it does not SEND but puts it in the OUTBOX. I have to click
> SEND/RECEIVE from the main page to actually SEND the emai...