Excel changed column header to numbers instead of letter

Hi Experts,

This one is a simple one but for the love of GOD i can't remember how to undo this.

My boss excel program changed all the headers in columns to numbers and  
now he has numbers running down the worksheet as well as accross.

What do i need to do to change it back to the normal way.

Thanks

WilsonJ
WilsonJAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jburgaardCommented:
functions->settings->standards->R1C1-ref.type
or seek help on R1C1 if my translation is poor
0
gonzal13RetiredCommented:
What did the headers have before and in the columns? I suspect that you have a date that is translated into a number.
0
paraghsDy General ManagerCommented:
Tools menu -> Options -> General -> Settings : R1C1 Reference Style
is the correct way (perhaps jburgaard translated it wrong)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
WilsonJAuthor Commented:
Thanks Paraghs and forgive my slow response.

WilsonJ
0
paraghsDy General ManagerCommented:
Glad to help, WilsonJ :)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Operating Systems

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.