• Answers
  • Web
Personalize Yedda, (And make Danny Happy)
People ask & answer about almost everything. Tell us what you're interested in... So we can personalize Yedda especially for you
I'm interested in:
Save
Cancel

Changing VALUE#! to zero in google speardsheet

I have created a spreadsheet for calculating my work hours. I used a pretty simple formula to calculate the sum of hours I worked by the time of the beginning and the end of my shift.

When I'm using Openoffice calc, the cell with formula of summing the hours gets the value of 0 if the source cells are empty, but when I imported it to Google Doc it gets the error value of VALUE#! .

Is there any way to change this error value back to zero?


Answer this question
Share Send to a friend Watch Report
 
 

Posted Answers

 
23 answers
10 helpful answers

First check your numbers. If you have decimals, make sure that decimal separator is right in Google Spreadsheet - should be full stop (.) instead of comma (,). Helped?

Posted 2007-01-08T10:24:23Z
EscApe was invited by Yedda to answer this question.

Helpful?(1)
Rated as Best Answer

Sign in to participate

Got an answer for King_Cobra_Show? Would you like to comment on the posted answers, or vote for the one which you think is the best?

Sign up for a free account, or sign in (if you're already a member).

Feed - Subscribe to changes to this Q&A Blog
ADVERTISEMENT
  • Answers
  • Web
Copyright © 2006-2009, Yedda Inc. and respective copyright owners · CC License