For numbers stored as text, convert them to a numeric format using the VALUE function before applying the square root calculation. The formula '=SQRT(VALUE(text))' first transforms the text to a numeric value using VALUE, then calculates its square root with SQRT. It's crucial when importing data from other sources that might not initially be in the correct format for calculations.