Formula returns 0 value

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

Guest

I've got data imported from a .mdb file into a spreadsheet. I'm trying to
create formulas based on this imported data. Some fields always return a 0
value, while others complete the formula. When looking at the properties of
the cell with the problems, the cell is locked. I unlock it, and format to a
number, however it doesnt' change... Any suggestions would be appreciated.
Ansley
 
The value is probably a text value and reformatting an existing cell won't change it.
To prove it (or at least see if this is the problem), copy a blank cell from anywhere in
the SS and then, after selecting the problem cell, Paste Special->Add.
This should force the text value to become a number.
 
Back
Top