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?


Would you like to answer or comment?

Sign up for a free account, or sign in (if you're already a member).
  • 990 views
Share Send to a friend Watch Report
 
 

Posted Answers

 
27 thumbs up

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 2 years ago ( permalink )
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:


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 1147 times

Last answer posted 4 months ago by lp22082


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 1 year ago
  • viewed 1787 times

Last answer posted 1 year ago by JtotheA


I need to create an excel formula in a spreadsheet ...

i need to create an excel formula in a spreadsheet that compares values from sheet1.column a to sheet2.column b and returns the ...
Submitted by Eyespi 2 years ago
  • viewed 1152 times

Last answer posted 2 years ago by Eyespi



» More...

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