Excel number from database dump not treated as number
I have an issue with a number that is part of a database dump from
Pastel evolution. It has a space after the first number
and Excel doesn't see this as a number. I have a hundred thousand records.
How can I convert this to a number using an Excel formula?