View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dylan @ UAFC[_2_] Dylan @ UAFC[_2_] is offline
external usenet poster
 
Posts: 76
Default Convert Text to numeric Value

I am trying to convert a string of text into a numeric value.
Ie,

I have several code legends to report results that need
to have a money value.
H1=154.00
H2=254.00

I would like to be able to type either of these code legeds in say A1
and then they will return the numeric value in say A45