Create a helper column and type 1. Next, apply a simple multiply using this formula: number (stored as text) * 1. A result is a number.