format text to numbers

D

Davidm

I am having trouble formating text to numbers. I tried copy a blank cell then
select area that I want formatted to numbers to 1 decimal place and then
paste special - Add and it worked fine the first time. But it wont seem to
work now after the first time no matter what I do.
What am I doing wrong. Even tried qiutting out of excel and restarted and
tried on another worksheet still no go

any help appreciated
Dave
 
S

Sheeloo

The procedure you have described should convert numbers stored as text to
numbers...
If you want to show only decimal place then after converting the range from
text to numbers choose Format->Cells and then specify the number of decimals
you want under Number format...

Instead of adding blank you can also multiply with 1 - enter 1 somewhere,
copy the cell and then paste special->multiply
 

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

Changing Text To Numbers ? 1
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Text to Numbers 4
Sum number range ignoring numbers formatted as text 0
Can General format numbers be mistaken as text? 6
delimited numbers 4
Convert numbers stored as text to numbers 2
Text vs Numbers 2

Top