View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
cedralpass cedralpass is offline
external usenet poster
 
Posts: 2
Default unable to get original cell value from a "number stored as text"

Unfortunately we can not loop through each cell, as these worksheets are very large. We are sucking out the data in bulk. Calliing a function each time would be very time consuming. When looping through each cell in a worksheet, extraction of the data takes over 2-3 minutes on a very fast box.