Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Adding problem

hello,
I copied and pasted some data from a web page into an excel ss.
1 column as fractions like:
0.10
0.10
0.20
0.10
0.20

I can't add up the column. I have them formatted as numbers, but
excel doesn't recognize them as such. All attempts to add from this
column equals 0.
Any ideas?
thanks

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
strange problem with links updates in excel [email protected] Excel Discussion (Misc queries) 1 April 23rd 06 10:59 AM
Adding or combining time problem. purtech Excel Worksheet Functions 1 April 16th 06 06:20 AM
problem adding rvnwdr Excel Discussion (Misc queries) 2 June 8th 05 06:36 PM
Adding summaries, rows and pre-population JFH New Users to Excel 1 May 24th 05 08:52 PM
problem with adding columns of numbers jeri_g Excel Worksheet Functions 1 January 11th 05 03:25 PM


All times are GMT +1. The time now is 11:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"