sathis (accounts executive) (311 Points)
12 November 2009Dear All,
Can any body know the formula for the following problem? When i go to enter number in one cell ( ie. 1000+1050.50=2050.5000) it will seperate in next cells like 2050 and 5000 lessthan or greater than digits.
Please go through the attachment.
Please send immediately.
Advance Thanks & Regards
Urs
Sathis
CA CS Manish Wadhwani
(Service Job)
(131 Points)
Replied 12 November 2009
| Originally posted by :sathis | ||
| " | You can do that by following the function of text to column which is there in ms excel 2007 under data. you just have to convert the formula into no. then use the function, you cannot use f5*f7 but you have to convert that into no. first. just use the separater as "." | " |
CA Mani
(Credit Analyst)
(2814 Points)
Replied 12 November 2009
Hi i tried to solve ur problem , byee
Hi
I tried by using "Left" nad "Right" formula.
See the attachement
Yeshwanth
(Chartered Accountant)
(145 Points)
Replied 12 November 2009
Hi sathis... Here is a solution for your problem
CA Prateek Garg
(CA in Practice)
(1447 Points)
Replied 13 November 2009
hi,
you can do it by using the formula "FLOOR".
see the attachment
Arun Mahajan
(Accountant)
(36 Points)
Replied 13 November 2009
Hi
You can use rounddown to solve your problem. Please see file
| Originally posted by :sathis | ||
| " | Dear All, Can any body know the formula for the following problem? When i go to enter number in one cell ( ie. 1000+1050.50=2050.5000) it will seperate in next cells like 2050 and 5000 lessthan or greater than digits. Please go through the attachment. Please send immediately. Advance Thanks & Regards Urs Sathis |
" |
CAclubindia
