Thread: =T() function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
neeraj
 
Posts: n/a
Default =T() function

I exported a file into an Excel spreadsheet. One of the columns has a =T( )
function which is preventing me from using the cells of this column for
Vlookup. For example, one of the cells is =T("39601") and the value is
evaluated to 39601. When I try to look this value up in a Vlookup, it returns
#N/A error. When I manually replace it bt 39601, Vlookup starts working. How
can I remove the =T from all the cells? What is this =T function