If your text values contain non-numeric characters, such as dollar signs or commas, you will need to remove them before converting to numbers. You can do this manually or use Excel's 'Replace' function to remove specific characters. Alternatively, you can use the 'Text to Columns' feature and select the option to 'Delimit' by the specific characters to remove them.