| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why are my spreadsheet columns numeric instead of alpha?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why are my spreadsheet columns numeric instead of alpha?
Tools/ Options/ General: Uncheck R1C1 reference style.
[... and next time, please put your question in the body of the text, not just in the subject line. A number of readers of the group will either not see the message, or be unable to reply if there is no text.] -- David Biddulph "gretchen" wrote in message ... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why are my spreadsheet columns numeric instead of alpha?
Tools|Options|General tab|Uncheck the R1C1 reference style box.
Excel picks this up from the first workbook you open in that session. gretchen wrote: -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why are my spreadsheet columns numeric instead of alpha?
R1C1 setting
See tools, options, general, r1c1 reference style. gretchen wrote: |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why are my spreadsheet columns numeric instead of alpha?
Unheck this setting:
ToolsOptionsGeneral tabR1C1 reference style Biff "gretchen" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| both columns and rows are numeric.want the columns to be alpha | Setting up and Configuration of Excel | |||
| only extract numeric value from alpha numeric cell | Excel Discussion (Misc queries) | |||
| HOW DO I CHANGE COLUMNS FROM NUMERIC TO ALPHA HEADINGS? | Excel Discussion (Misc queries) | |||
| Columns are now numeric, not alpha. how to change back? | Excel Discussion (Misc queries) | |||
| The colums changed from alpha to numeric how do you make it alpha | Excel Discussion (Misc queries) | |||
Linear Mode
