You can just change the format of the cells to "General". All the commas
will disappear and the dots will remain.
Regards,
Nikhil Damle.
Chartered Accountant.
On Fri, Feb 6, 2009 at 9:38 AM, Sathish Jalendran wrote:
> U can use find and replace..
>
>
>
> Rega
Dear Ahmed,
You can use a very simple "If" formula.
Consider the first admission."NSA/250/30. Just type the following in your
sheet - "=if(B2<>0,D2,0) and then copy the formula. Take the sum of this
column.
Regards,
Nikhil.
On Sat, Oct 18, 2008 at 2:08 PM, Ahmedhonest <[EMAIL PROTECTED]> wrot