Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Applying Indian comma style | Excel Discussion (Misc queries) | |||
Removing numbers from the beginning of a text string | Excel Worksheet Functions | |||
Removing a space after a comma | New Users to Excel | |||
Comma is not visible in Excel | Excel Discussion (Misc queries) | |||
HELP - I need to change space delimited to comma? | Excel Discussion (Misc queries) |