• Answers
  • Web

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?


Share Send to a friend Watch Report
 
 

Posted 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).

Explore Related Questions

Other people asked questions on similar topics, check out the answers they received:


Q:

Sample Succession PLans in Excel FOrmat

Does anyone have ideas for excel sheet for succesion plans?
Submitted by careymm   4 months ago.
  • viewed 178 times


Q:

The best office suite

Which one would you recommend as the best office suite - OpenOffice, MS Office 2007 or some other? Please share your comments. Do ...
Submitted by drabsv   3 years ago.
  • viewed 1405 times
Last answer posted 18 days ago by alicetare cook


Q:

VB script for Excel spreadsheet printing

I wish to write a vba script I can run for a spreadsheet in MS Excel that only prints only the rows for a column (let's say ...
Submitted by JtotheA   2 years ago.
  • viewed 2097 times
Last answer posted 2 years ago by JtotheA



» More...

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