LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lucas
 
Posts: n/a
Default removing comma

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Applying Indian comma style NAVEEN Excel Discussion (Misc queries) 1 February 22nd 06 08:59 AM
Removing numbers from the beginning of a text string Night Owl Excel Worksheet Functions 3 May 13th 05 05:52 PM
Removing a space after a comma DebbieK9 New Users to Excel 3 April 1st 05 10:08 PM
Comma is not visible in Excel DrNASA Excel Discussion (Misc queries) 1 March 10th 05 04:51 PM
HELP - I need to change space delimited to comma? Mayer Excel Discussion (Misc queries) 1 December 18th 04 06:21 PM


All times are GMT +1. The time now is 11:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"