[mso] Re: An Excel Question

It may not be fancy, but the following Integer division method works all the 
time -
Notice that in your example
D6 = 25750
I6 = INT(D6/10000)
J6 = INT((D6-I6*10000)/1000)
K6 = INT((D6-I6*10000-J6*1000)/100)
L6 = INT((D6-I6*10000-J6*1000-K6*100)/10)
M6 = D6-I6*10000-J6*1000-K6*100-L6*10
Jonathan

joby john <john_joby@xxxxxxxxx> wrote: 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 
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
*************************************************************


       

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