Trying to write a list of numbers in a cell, keeps converting it to a long number

Hey, I'm doing the website for my company and things have to be entered into the site via spreadsheets. I have a list of numbers

e.g. 3652, 2845, 50925, 4809, 18392

that need to have the spaces removed in order for them to work.

e.g. 3652,2845,50925,4809,18392

There are over 500 cells with multiple numbers in each, so I don't want to do it one at a time, and rightly so, because Excel keeps changing the format and giving me something like

3.6*10^30 and loses all my commas.

Is there an easier way?

Hi,

Format the cells as text before entering the values.

You can use a formula in an adjacent cell.

e.g

=SUBSTITUTE(A1," ","") copied down

Then you can copy and paste|special >> Values over the original and get rid of the formula cells.

So let's say your numbers are currently residing in range A2:A100, well then in an empty cell in row 2, enter formula: =Substitute(A2," ","") this should convert it to what you need.

Copy that formula down the column... by click and dragging little black square at bottom right corner of first cell with formula...

Then copy that new range of formula cells, go to A2 and then go to Edit|Paste Special and select Values. Clikc Ok. This should overwrite your old stuff with the new...

Now you can go ahead and delete the column you added with formulas...

Note: Please save your original file first in case things get messed up.