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 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 |
" |
CAclubindia
