VMware vSphere Hypervisor 5.5 Licen...
VMware vSphere Hypervisor 5.5 License Activation [2020 Updated]
Guide,  Microsoft

Microsoft Excel – Columns Displaying Numbers instead of Letters
0 (0)

We have recently dealt with a problem that a customer had reported to us about their Excel spreadsheet columns suddenly appearing as numbers instead of the expected letters.

We doubted this very much as none of us had heard of it before, but no, there is was, columns as numbers just like this:

Microsoft Excel - Columns Displaying Numbers instead of Letters 1

This was a bit baffling to us, but is very easy to fix. This type of formatting for the columns is called R1C1 reference style. It is not a problem as such, just a different way of doing things, but as most people will want their Excel columns as letters, there is an easy way to revert this.

To show this easier, we have created a quick video guide on how to put this back to letter formatting:

VIDEO

COMMENTS

If you have any questions or comments about this guide, please feel free to use our comments system below.

Click to rate this post!
[Total: 0 Average: 0]

Free Subscription

If you want to be notified when we post more quality guides like this one, sign up to our free subscription service and you will receive an email when a new post is live.

Join 449 other subscribers.

No need to worry, we will not be filling your inbox with spam and you can unsubscribe anytime you like.

Avatar of A.J. Armstrong

Founder of TechyGeeksHome and Head Editor for over 12 years! IT expert in multiple areas for over 22 years. Sharing experience and knowledge whenever possible! Making IT Happen.

Leave us a message...

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