[mso] Re: An Excel Question

=Value(Mid(...))

----- Original Message ----- 
From: "joby john" <john_joby@xxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Friday, June 06, 2008 11:53 PM
Subject: [mso] Re: An Excel Question


> Dear all,
> I wanted to create a form in excel, first sheet would be data input sheet 
> and second sheet would be the "form "with no manual inputs.
> In data input sheet cells d6,d7,d8,d9,d10 , are for numbers , ie in d6 i 
> have to key in Income Tax amount, d7 Sur charge amount , d8 other cess 
> amount ..etc
> In second sheet ie sheet "Form" 6 rows( ie 6 to 11 ), and in each row 10 
> cells ( ie D6,E6....to M6 for Income tax amount ,same way D7,E7 to M7 for 
> surcharge amount. .D11,E11,...to M11 for total (sum)of cells appears 
> above ) are dedicated for this numbers
> When I enter a Number in Data input sheet , say in D6 i enter 25750 , in 
> Sheet form it would appear as follows
> in M6 0 , L6 5 , K6 7 , J6 5, I6 2
> and in raw 11 , i would like to arrive the sum of all the five cells above 
> and also whatever numbers are there in Raw 11, it would appear in words in 
> row 12
> I tried using formula MID , but once i use the formula excel recognise the 
> number as text
> Hope you guys help me out
> Thanks in advance
> John
>
>
> ----- Original Message ----
> From: joby john <john_joby@xxxxxxxxx>
> To: mso@xxxxxxxxxxxxx
> Sent: Friday, June 6, 2008 12:37:38 PM
> Subject: [mso] An Excel Question
>
>
>
> *************************************************************
> 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: 269.24.6/1487 - Release Date: 6/6/2008 
> 8:01 AM
>
> 

*************************************************************
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: