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
| 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 |
" |
Getmyca Consultant Pvt Ltd
New Delhi
CA Inter
View Details
Chirag P Shah & Co. Chartered Accountant
Pune
B.Com
View Details
Subrahmanyam & Sivudu CA Firm
Hyderabad
CA Inter
View Details
Anupam Parashar & Co.
Ghaziabad
CA Final
View Details
CCI
Pro
CAclubindia
