How do I modify row column format of Excel sheet?
 

My spreadsheet has rows & columns in numeric format where I want it to be
alphnumeric for columns & numeric for rows.

This is messing up my calculations... I'm sure it's something simple but
can't figure it out.

Thanks.

Jon

Click Tools Options General tab
Uncheck R1C1 reference style OK

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Mr. Good" <Mr. wrote in message
...
My spreadsheet has rows & columns in numeric format where I want it to be
alphnumeric for columns & numeric for rows.

This is messing up my calculations... I'm sure it's something simple but
can't figure it out.

Thanks.

Jon

Thanks Max!!! Much appreciated!

Jon

"Max" wrote:

Click Tools Options General tab
Uncheck R1C1 reference style OK

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Mr. Good" <Mr. wrote in message
...
My spreadsheet has rows & columns in numeric format where I want it to be
alphnumeric for columns & numeric for rows.

This is messing up my calculations... I'm sure it's something simple but
can't figure it out.

Thanks.

Jon

You're welcome, Jon !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Mr. Good" <Mr. wrote in message
...
Thanks Max!!! Much appreciated!

Jon