Formatting

T

twinclstar

I have uploaded an excell spreadsheet and can't seem to be able to fromat the
numbers correctly.

the numbers are listed like so: 1 578
how can I cange the format to: 1,578 (with no space so that I can use for
formulas?)
 
S

SAL

How about try format - Cell - select Number and check the box for Use 1000
Separator (,).

If this doesn't work, you need change your format using Value function.
=value(A1)
 
S

SAL

I think you have spaces between the numbers and excel treats this as text.
Lets try removing the spaces using, Edit - Replace and hit space bar once on
click on replace. It will remove the space between the numbers. do you have
yahoo IM?
 
S

snow

It worked great. You are a genious.

SAL said:
I think you have spaces between the numbers and excel treats this as text.
Lets try removing the spaces using, Edit - Replace and hit space bar once on
click on replace. It will remove the space between the numbers. do you have
yahoo IM?
Click to expand...
 
Top