Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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?
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change the format of cell 1
If then Formula 3
Copying conditional formating 5
Cell that will not format 6
copy-maping cells from one to another workwsheet 1
Date and time 1
How to create a conditional format that changes the number format 1
Conditional formatting does not follow value when list is sorted 3

Back
Top