Hi, Remove the spaces and comma by "Search and Replace (Ctrl+H)" option. Then try converting to numbers.
With Regards, Karthi On Fri, Aug 26, 2011 at 7:17 PM, Amit Desai (MERU) <amit.de...@merucabs.com>wrote: > Dear Friends,**** > > ** ** > > I have recd the following data in email body itself & wants to convert them > in number to have sum of it. Let me know how to convert them in numbers.** > ** > > > **** > > *Cost by Activity* > > * * > > * * > > *Total Cost * > > *PM* > > *RR* > > *AR* > > *TYRES* > > *BATTERY* > > *Towing* > > 1,01,602.00 **** > > 93,85,047.00 **** > > 22,41,109.00 **** > > **** > > **** > > **** > > 1,17,27,758.00 **** > > 3,80,161.00 **** > > 5,33,958.00 **** > > 92,364.00 **** > > **** > > **** > > **** > > 10,06,483.00 **** > > 2,42,051.10 **** > > 4,56,682.90 **** > > 1,08,103.00 **** > > **** > > **** > > **** > > 8,06,837.00 **** > > 2,59,323.60 **** > > 3,88,985.40 **** > > **** > > **** > > **** > > **** > > 6,48,309.00 **** > > **** > > **** > > **** > > 1,356,175.00 **** > > **** > > **** > > 1,356,175.00 **** > > **** > > 3,000.00 **** > > **** > > **** > > **** > > **** > > 3,000.00 **** > > **** > > 1,63,000.00 **** > > **** > > **** > > **** > > **** > > 1,63,000.00 **** > > **** > > **** > > **** > > **** > > 860,969.00 **** > > **** > > 860,969.00 **** > > **** > > **** > > **** > > **** > > **** > > 558,177.00 **** > > 558,177.00 **** > > 2,75,676.00 **** > > 4,13,514.00 **** > > **** > > **** > > **** > > **** > > 6,89,190.00 **** > > 5,20,683.00 **** > > 13,01,019.00 **** > > 22,280.00 **** > > **** > > **** > > **** > > 18,43,982.00 **** > > 2,52,851.60 **** > > 3,79,277.40 **** > > **** > > **** > > **** > > **** > > 6,32,129.00 **** > > **** > > 2,26,000.00 **** > > **** > > **** > > **** > > **** > > 2,26,000.00 **** > > * 20,32,348.30 * > > * 1,32,50,483.70 * > > * 24,63,856.00 * > > * 1,356,175.00 * > > * 860,969.00 * > > * 558,177.00 * > > * 20,522,008 * > > ** ** > > ** ** > > Best Regards,**** > > Amit Desai**** > > ** ** > > ------------------------------ > Disclaimer: This message and its attachments contain confidential > information and may also contain legally privileged information. This > message is intended solely for the named addressee. If you are not the > addressee indicated in this message (or authorized to receive for > addressee), you may not copy or deliver any part of this message or its > attachments to anyone or use any part of this message or its attachments. > Rather, you should permanently delete this message and its attachments (and > all copies) from your system and kindly notify the sender by reply e-mail. > Any content of this message and its attachments that does not relate to the > official business of Meru Cab Company Pvt. Ltd. must be taken not to have > been sent or endorsed by any of them. Email communications are not private > and no warranty is made that e-mail communications are timely, secure or > free from computer virus or other defect. > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- KARTHI KUMAR. N -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel