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