Converting text to number in Excel It took me too long to figure out how to typecast a string to a number in Excel. Preserving it here for posterity; use the "=VALUE()" function. Published: April 08 2011 category: tags: Tweet