removing comma

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Go to Edit->Replace

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

Thx for advice. It helps!

David McRitchie said:
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
Click to expand...
 
Back
Top