excel formula to seperate

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: 376 times
Replies (6)
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 "." "


 

Hi i tried to solve ur problem , byee

Hi

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

See the attachement

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

hi,

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

see the attachment

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

 
"

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details
Company
31 October 2026
Accountants

sankaran and krishnan

New Delhi

B.Com

View Details
Company
20 November 2026
Charted Accountant

Cothas Coffee Co.

Bengaluru

CA

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details
Company
12 November 2026
Tax Product Specialist

BharatX.ai

Gurgaon

B.Com

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details