title: How can multiply a value I enter in an excel cell by a constant number, with result on appearing on same cell?
body: <p>I have an Excel spreadsheet where I need to enter values in days in cells in one column, and automagically convert those to seconds. How can I do this?</p>
  
  <p>For example, say I want to have values in column B reflected as seconds. So in B1 I type 1, press Enter, and now the value in B1 is 86400; in B2 I type 2, press Enter, B2 becomes 172800.</p>
  
  <p>Clearer?</p>