| 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 | |||
Hybrid Mode
