I am working with output from a corporate accounting system. When data is
exported to Excel for Canadian operations the numbers are always represented
as text in the following format C$125.44.

I can't figure out how to quickly convert the data from text to numbers. If
I remove the C then Excel recognizes a number. Is there a fuction that will
remove only the leftmost character of a string? Or must I write a macro that
can do so?

Thank you.