title: Getting around circular reference in Google Spreadsheet
body: <p>I have a google docs spreadsheet with two columns: A and B.
  Values of B are just values from A in a different format, and I have a formula in the B column that does the conversion.
  Sometimes I do not have the values in A format but I have them in B format. I would like to automatically get the values in A format in the A column by adding the formula that does the reverse conversion in the A column. This, of course, generates a circular reference. Is there a way to get around it?  </p>