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?)

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)


"twinclstar" wrote:

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?)

The format cell doesn't work it. How would I set up the value formula?

"SAL" wrote:

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)


"twinclstar" wrote:

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?)

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?

"twinclstar" wrote:

The format cell doesn't work it. How would I set up the value formula?

"SAL" wrote:

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)


"twinclstar" wrote:

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?)

It worked great. You are a genious.

"SAL" wrote:

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?

"twinclstar" wrote:

The format cell doesn't work it. How would I set up the value formula?

"SAL" wrote:

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)


"twinclstar" wrote:

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?)