View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
kleivakat kleivakat is offline
external usenet poster
 
Posts: 29
Default Simple formula question

One more very strange thing. I just re-entered a couple of numbers exactly
as they show up in the cell, and the numbers that I re-entered are calculated
in the formula, just not the other numbers that were imported. I've tried
copying and paste special (values), and that doesn't help. It's a fairly
long sheet, so I really don't want to retype the numbers if I don't have to.

"akphidelt" wrote:

Just a random question, when you highlight one of the cells does a clipboard
pop up? Most of the time when I import data if a number is showing up as text
you'll be able to change it by highlighting the data and clicking the
clipboard and changing the value to a number.

"kleivakat" wrote:

I'm trying to add up numbers in a column. It should be very simple, but I
keep getting a zero result. The formula is =sum(J5:J113). I thought that
the problem was maybe in the formatting of the numbers in column J since they
were exported from another program, so I went into the Format menu and made
sure they were formatted as currency. I'm still getting a zero result. Any
other suggestions?