Take ti as a challenge!!!any one can help me?

comet_111999 · 04-05-2009, 03:38 AM

Hi All,
Im attaching one excel file,any one can remove the comma in the columns B and E(Amount).I tried alot,changing format styles, and system regional settings like that so many.No change. Please help me...........

Now i can't attach the excel file. Sorry..........

Please give me some solutions

Tnx in advance.........

**wrench97** · 04-05-2009, 04:24 AM

In the format dialog box untic the thousands separator box?

comet_111999 · 04-05-2009, 11:46 PM

Quote:

Originally Posted by wrench97

In the format dialog box untic the thousands separator box?

Bull *****

Only this?i tried my level best.I done like that before you tell to me.I need solutions that is coming from a genious.i am a computer proffessional. please replay some other detailed solutions................

**wrench97** · 04-06-2009, 01:30 AM

Good luck

**djaburg** · 04-06-2009, 01:47 AM

Well first of all if you WERE a computer professional you'd know how to act when asking for help. Second, if you HAD tried other things, it might be nice to enlighten us as to what you've already tried. Third, genious is not a word, GENIUS is. Fourth, a computer professional would surely know to explain what version of Excel they were requesting help on since each version can have it's own way of doing things...but I'm sure you already knew that.

Dang, I found the answer in two minutes just poking around. Hmm....professional?

04-05-2009, 03:38 AM	#1 (permalink)
comet_111999 Registered User Join Date: Feb 2009 Posts: 11 OS: xp	Take ti as a challenge!!!any one can help me? Hi All, Im attaching one excel file,any one can remove the comma in the columns B and E(Amount).I tried alot,changing format styles, and system regional settings like that so many.No change. Please help me........... Now i can't attach the excel file. Sorry.......... Please give me some solutions Tnx in advance.........

04-06-2009, 01:30 AM	#4 (permalink)
wrench97 Moderator, Hardware Team Join Date: May 2008 Location: S.E. Pennsylvania Posts: 18,621 OS: Win7	Re: Take ti as a challenge!!!any one can help me? Good luck __________________ Power Supply and Selection

04-06-2009, 01:47 AM	#5 (permalink)
djaburg TSF Enthusiast Join Date: May 2008 Posts: 1,321 OS: XP SP3/Vista/7 Server 2K/2K3/2K8	Re: Take ti as a challenge!!!any one can help me? Well first of all if you WERE a computer professional you'd know how to act when asking for help. Second, if you HAD tried other things, it might be nice to enlighten us as to what you've already tried. Third, genious is not a word, GENIUS is. Fourth, a computer professional would surely know to explain what version of Excel they were requesting help on since each version can have it's own way of doing things...but I'm sure you already knew that. Dang, I found the answer in two minutes just poking around. Hmm....professional? __________________ Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done. The inherent vice of capitalism is the uneven division of blessings, while the inherent virtue of socialism is the equal division of misery.