title: WorksheetFunction.value() missing in Excel
body: <p>In a spreadsheet formula, <code>=VALUE("$100")</code> will evaluate to the numeric value of 100.  I then tried to access this function in VBA via WorksheetFunction object, however it is missing.</p>
  
  <p>In VBA I tried the conversion function <code>Val("$100")</code>, however that returns 0.  So how can I accomplish this via VBA?</p>