Excel 2007: Remove the space between thousands
Solved
chtiotte59
Posted messages
24
Status
Membre
-
nono -
nono -
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.
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
3 réponses
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
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
Inat
A big thank you for this solution. I didn't know about it at all.
Amish
Thanks for the help.