software

Hi Guys!

I have a problem with cell formatting. From IT system I export to excel the
report. The values however are written in 'stupid' way. For example 3000 is
written as 3,000. It's not the matter of cell formatting, so the figure
inside the cell is not 3000 and just presented as 3,000 because of setting up
thousands separator, but the number inside the cell is written as 3,000. So
Excel doesn't recognize this 3,000 and once I remove the comma everything is
fine. But I know only how to remove the comma manually - any idea how to do
this by function?

thx, lucas

Hi Lucas,
In other words you have text strings, which are by default aligned on the
left but that can be overridden.

Use Ctrl H (change) to change a comma to nothing
Once you have done that you will still have strings, for which you could
hit F2 then Enter for each and it would become a number unless you
have formatted the cell to be text. Make sure you have General or
something that you want for the format before reentering.
You can make the reentry simpler by using the TrimALL macro at
www.mvps.org/dmcritchie/excel/join.htm#trimall
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;lucasquot; gt; wrote in message ...
gt; Hi Guys!
gt;
gt; I have a problem with cell formatting. From IT system I export to excel the
gt; report. The values however are written in 'stupid' way. For example 3000 is
gt; written as 3,000. It's not the matter of cell formatting, so the figure
gt; inside the cell is not 3000 and just presented as 3,000 because of setting up
gt; thousands separator, but the number inside the cell is written as 3,000. So
gt; Excel doesn't recognize this 3,000 and once I remove the comma everything is
gt; fine. But I know only how to remove the comma manually - any idea how to do
gt; this by function?
gt;
gt; thx, lucas

Go to Edit-gt;Replace

Choose find ' and replace with quot;quot; (Two quotation marks represents
blank)--
mphell0
------------------------------------------------------------------------
mphell0's Profile: www.excelforum.com/member.php...oamp;userid=30153
View this thread: www.excelforum.com/showthread...hreadid=520545
gt;Go to Edit-gt;Replace

gt;Choose find ' and replace with quot;quot; (Two quotation marks represents
blank)

I'm sorry my brain is moving slow today. It should be:

Find , (comma) and leave the replace field blank.--
mphell0
------------------------------------------------------------------------
mphell0's Profile: www.excelforum.com/member.php...oamp;userid=30153
View this thread: www.excelforum.com/showthread...hreadid=520545Guys,

Thx for advice. It helps!

quot;David McRitchiequot; wrote:

gt; Hi Lucas,
gt; In other words you have text strings, which are by default aligned on the
gt; left but that can be overridden.
gt;
gt; Use Ctrl H (change) to change a comma to nothing
gt; Once you have done that you will still have strings, for which you could
gt; hit F2 then Enter for each and it would become a number unless you
gt; have formatted the cell to be text. Make sure you have General or
gt; something that you want for the format before reentering.
gt; You can make the reentry simpler by using the TrimALL macro at
gt; www.mvps.org/dmcritchie/excel/join.htm#trimall
gt; ---
gt; HTH,
gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt;
gt; quot;lucasquot; gt; wrote in message ...
gt; gt; Hi Guys!
gt; gt;
gt; gt; I have a problem with cell formatting. From IT system I export to excel the
gt; gt; report. The values however are written in 'stupid' way. For example 3000 is
gt; gt; written as 3,000. It's not the matter of cell formatting, so the figure
gt; gt; inside the cell is not 3000 and just presented as 3,000 because of setting up
gt; gt; thousands separator, but the number inside the cell is written as 3,000. So
gt; gt; Excel doesn't recognize this 3,000 and once I remove the comma everything is
gt; gt; fine. But I know only how to remove the comma manually - any idea how to do
gt; gt; this by function?
gt; gt;
gt; gt; thx, lucas
gt;
gt;
gt;