Excel 2007: Remove the space between thousands Solved

Question

Hello,
I downloaded stock prices (ranging from 1000 to 2000 points) from a stock market site. However, I need to perform a whole series of calculations on these values. When I enter my formulas related to these cells containing thousands, I get #VALUE!
The problem actually comes from the format of these values: they are thousands with a space (like 1 500.45) when I need 1500.45. I don't know how to remove that space except manually (which is tedious since I have about 300 values....)
Can someone please help me ?? I'm using Windows XP and Excel 2007.

Configuration: Windows XP Internet Explorer 7.0

gbinforme · Accepted Answer

Hello  Indeed, these are thousands with a space (type 1 500,45)  The problem probably comes from the fact that your space is a non-breaking space that has been used.  With ctrl + h in search, you enter alt + 255 (non-breaking space) and you replace all --  Always zen

bobynette1 · Answer

select the concerned column by clicking on its letter, for example J
right-click on the letter when the column is highlighted
cell format
in category choose number
choose your number of decimal places
and uncheck the thousand separator box and you’re done

VX Consult · Answer

Was the export done in an Excel file or a txt file? I had the same problem and you need to ensure that you have a file of type xls and not txt in Excel. Then you need to do as gbinforme explained or directly copy and paste the extra space between your numbers in the search field.

Excel 2007: Remove the space between thousands

3 answers

Word icon on taskbar replaced by a blank page

Which backup parts could i delete?

Vba to hide and unhide rows

Unable to print a document

Toshiba c70d-a-111 image/recovery disk search

Connect a dvd player to a windows 10 pc

Excel vba if with 2 conditions

Smartphone usb ports: a little-known yet highly practical feature

Change the toolbar font size

My computer stays connected for very little time