Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Standard Balance Sheet format in Microsoft Office Excel 2003(2) | Excel Worksheet Functions | |||
Conditional Format using value from another sheet | Excel Worksheet Functions | |||
Excel should provide an easy way to switch a column into a row, n. | Excel Discussion (Misc queries) | |||
Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel | |||
Format excel sheet where one row is silver and the next white ??? | New Users to Excel |