Forum Discussion
Remove a comma from a number treated as text
Greetings! I'm new to this forum, and I don't know if this is the right place to ask. But, here it goes: I have a column of currency values which is a mess. I managed to clean it as much as possib...
The Excel function VALUE will convert text that may be regarded as a number back to the number.
= VALUE(text)Cut and paste will overwrite the original text if required.