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
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"lucas" wrote in message ...
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

Go to Edit-Replace

Choose find ' and replace with "" (Two quotation marks represents
blank)


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=520545

Go to Edit-Replace

Choose find ' and replace with "" (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: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=520545

Guys,

Thx for advice. It helps!

"David McRitchie" wrote:

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
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"lucas" wrote in message ...
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