=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

=T() function
 

This is the text function:

Put 1 in a un-used cell
Copy the cell
Select the cells with the T() function
Paste/Special with multiply checked

You will now have a modified formula, but it will be a usable number.
--
Gary's Student


"neeraj" wrote:

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