$$Excel-Macros$$ Re: How to filter "," from data in cell.

2009-02-08 Thread Nikhil Damle
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

$$Excel-Macros$$ Re: Request for Formula

2008-10-18 Thread Nikhil Damle
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