Forum Discussion
Solved
Converting Text to numbers
I have statements in CSV format converted to text in excel. Pproblem the numbers are seperated with a comma as the thousand seperator and a dot for the decimal i.e. 10,562.98. They can therefore not...
Hi Nicolino, thank you for your speedy reply, much appriciated. Im not at all clued up in VBA so tried the formula instead however there is an error message I receive "Not trying to type a formula?"...
- The error message “Not trying to type a formula?” usually appears when you enter a formula into a cell but forget to start it with an equal sign (=). Make sure that you have entered the formula correctly and that it starts with an equal sign.
If you are still receiving this error message after checking the formula, there may be another issue causing the problem. Could you provide more information about the context in which you are using this formula and any other details that might be relevant?
Have you used the other formulas from the other users here? If so, does the same problem appear? ...just ask..which Excel version, operating system, storage medium?Hi Nicolino,
Thanks again for your response.
The formula is copied and correct, incl (=).I work on windows 11, and Office 365, 64 bits.
I've attached both files, the CVS and the xlsx, perhaps this makes it easier.
Thanks again for your assistance
Regards
Sepp
