One Minute to Excel #23 – Text numbers to real number again

Another solution

One thing you learn quickly about Excel is that there are many ways to achieve the same outcome.

This is another example. In an earlier video I showed two separate ways to convert text numbers into real numbers.

Well, I have just learned another way. An Excel MVP Rick Rothstein shared a third way.  I tweaked it and share a keyboard shortcut to do it as well.

Hope you enjoy it.

Added Nov 27, 2021

If you use Text to Columns for other conversion in the same session, you may need to use Alt A E W F as the Delimiter defaults may interfere with the conversion.

 

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.