Save Rs 499 on a 2-Year Ad-Free CAclubindia Pro Membership. Subscribe Now!

excel formula to seperate

1509 views 6 replies

sathis

accounts executive

311 Points Posted on 12 November 2009

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

Attached File : 12 excel.xls downloaded: 360 times

Replies (6)

CA CS Manish Wadhwani

Service Job

131 Points Posted on 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 Posted on 12 November 2009

Hi i tried to solve ur problem , byee

Guest

I tried by using "Left" nad "Right" formula.

See the attachement

Yeshwanth

Chartered Accountant

145 Points Posted on 12 November 2009

Hi sathis... Here is a solution for your problem

CA Prateek Garg

CA in Practice

1447 Points Posted on 13 November 2009

hi,

you can do it by using the formula "FLOOR".

see the attachment

Arun Mahajan

Accountant

36 Points Posted on 13 November 2009

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	"