View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Davidm Davidm is offline
external usenet poster
 
Posts: 20
Default format text to numbers

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