Re: $$Excel-Macros$$ Values are not calculating in number format

2017-10-12 Thread joseph abi
Dear Mr. praveen In your file some unwanted character which is invisible in the front of each numbers are hidden. That is the reason the number is considered as text by excel and you are unable to calculate. This is very small data I have manually removed the character in each cell. to remove coma

$$Excel-Macros$$ Values are not calculating in number format

2017-10-11 Thread Pravin Gunjal
Dear Friends, Greetings! I need to calculate SUM OR COUNT formula's for column D & E but it seems these values are not in number format. Could you please guide me how to convert them in number. As there is *space & comma *given before all the values. *With regards,**Pravin Gunjal* *Mobile: 7710