[mso] Re: An Excel Question

Conversion of numbers to words is one of the most frequently asked Excel 
questions.  Do a Google search for many examples.

Regards, Dave S

PS  Question.  What method are you using to post your messages to the group? 
It is converting parts of the text to HTML equivalents.  No one else seems 
to be having the same problem.

----- Original Message ----- 
From: "joby john" <john_joby@xxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Saturday, June 07, 2008 2:43 PM
Subject: [mso] Re: An Excel Question


> Thank you David
> &nbsp;
> &nbsp;Is there a way to translate the number into words?
> &nbsp;for example for 152&nbsp; , One Five Two or One Hundered and Fifty 
> two!
> &nbsp;
> Regards
> John
> --- On Fri, 6/6/08, David Smart &lt;smartware@xxxxxxxxxxxxxxx&gt; wrote:
>
> From: David Smart &lt;smartware@xxxxxxxxxxxxxxx&gt;
> Subject: [mso] Re: An Excel Question
> To: mso@xxxxxxxxxxxxx
> Date: Friday, June 6, 2008, 8:11 PM
>
> =Value(Mid(...))
>
> ----- Original Message ----- 
> From: "joby john" &lt;john_joby@xxxxxxxxx&gt;
> To: &lt;mso@xxxxxxxxxxxxx&gt;
> Sent: Friday, June 06, 2008 11:53 PM
> Subject: [mso] Re: An Excel Question
>
>
> &gt; Dear all,
> &gt; I wanted to create a form in excel, first sheet would be data input 
> sheet
> &gt; and second sheet would be the "form "with no manual inputs.
> &gt; In data input sheet cells d6,d7,d8,d9,d10 , are for numbers , ie in 
> d6 i
> &gt; have to key in Income Tax amount, d7 Sur charge amount , d8 other 
> cess
> &gt; amount ..etc
> &gt; In second sheet ie sheet "Form" 6 rows( ie 6 to 11 ), and in
> each row 10
> &gt; cells ( ie D6,E6....to M6 for Income tax amount ,same way D7,E7 to M7 
> for
> &gt; surcharge amount. .D11,E11,...to M11 for total (sum)of cells appears
> &gt; above ) are dedicated for this numbers
> &gt; When I enter a Number in Data input sheet , say in D6 i enter 25750 , 
> in
> &gt; Sheet form it would appear as follows
> &gt; in M6 0 , L6 5 , K6 7 , J6 5, I6 2
> &gt; and in raw 11 , i would like to arrive the sum of all the five cells 
> above
>
> &gt; and also whatever numbers are there in Raw 11, it would appear in 
> words in
>
> &gt; row 12
> &gt; I tried using formula MID , but once i use the formula excel 
> recognise the
>
> &gt; number as text
> &gt; Hope you guys help me out
> &gt; Thanks in advance
> &gt; John
> &gt;
> &gt;
> &gt; ----- Original Message ----
> &gt; From: joby john &lt;john_joby@xxxxxxxxx&gt;
> &gt; To: mso@xxxxxxxxxxxxx
> &gt; Sent: Friday, June 6, 2008 12:37:38 PM
> &gt; Subject: [mso] An Excel Question
> &gt;
> &gt;
> &gt;
> &gt; *************************************************************
> &gt; You are receiving this mail because you subscribed to 
> mso@xxxxxxxxxxxxx or
>
> &gt; MicrosoftOffice@xxxxxxxxxxxxxxxx
> &gt;
> &gt; To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
> &gt;
> &gt; To Unsubscribe from this group, visit the group's homepage and use 
> the
>
> &gt; dropdown menu at the top.  This will allow you to unsubscribe your 
> email
> &gt; address or change your email settings to digest or vacation (no 
> mail).
> &gt; http://www.freelists.org/webpage/mso
> &gt;
> &gt; To be able to share files with the group, you must join our Yahoo 
> sister
> &gt; group.  This group will not allow for posting of emails, but will 
> allow
> &gt; you to join and share problem files, templates, etc.:
> &gt; http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is 
> for
> &gt; FILE SHARING ONLY.
> &gt;
> &gt; If you are using Outlook and you see a lot of unnecessary code in 
> your
> &gt; email messages, read these instructions that explain why and how to 
> fix
> &gt; it:
> &gt; http://personal-computer-tutor.com/abc3/v28/greg28.htm
> &gt; *************************************************************
> &gt;
> &gt;
> &gt; -- 
> &gt; No virus found in this incoming message.
> &gt; Checked by AVG.
> &gt; Version: 7.5.524 / Virus Database: 269.24.6/1487 - Release Date: 
> 6/6/2008
> &gt; 8:01 AM
> &gt;
> &gt;
>
> *************************************************************
> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
> MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
> To Unsubscribe from this group, visit the group's homepage and use the
> dropdown menu at the top.  This will allow you to unsubscribe your email
> address or change your email settings to digest or vacation (no mail).
> http://www.freelists.org/webpage/mso
>
> To be able to share files with the group, you must join our Yahoo sister 
> group.
> This group will not allow for posting of emails, but will allow you to 
> join and
> share problem files, templates, etc.:
> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for 
> FILE
> SHARING ONLY.
>
> If you are using Outlook and you see a lot of unnecessary code in your 
> email
> messages, read these instructions that explain why and how to fix it:
> http://personal-computer-tutor.com/abc3/v28/greg28.htm
> *************************************************************
>
>
>
>
> *************************************************************
> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
> MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
> To Unsubscribe from this group, visit the group's homepage and use the 
> dropdown menu at the top.  This will allow you to unsubscribe your email 
> address or change your email settings to digest or vacation (no mail).
> http://www.freelists.org/webpage/mso
>
> To be able to share files with the group, you must join our Yahoo sister 
> group.  This group will not allow for posting of emails, but will allow 
> you to join and share problem files, templates, etc.: 
> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for 
> FILE SHARING ONLY.
>
> If you are using Outlook and you see a lot of unnecessary code in your 
> email messages, read these instructions that explain why and how to fix 
> it:
> http://personal-computer-tutor.com/abc3/v28/greg28.htm
> *************************************************************
>
>
> -- 
> No virus found in this incoming message.
> Checked by AVG.
> Version: 7.5.524 / Virus Database: 270.0.0/1488 - Release Date: 6/06/2008 
> 5:48 PM
> 

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: