| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
numbers instead of letters
Hi all
(Excel 2002) A colleague of mine was working on a spreadsheet and while working on it the columns which are normally letters have changed to numbers!! So now there is rows and columns in numbers (no letters). They do not remember pressing anything (or at least they ain't admitting it!). Can anyone help me put it back to normal? Any help greatly appreciated Kind regards Rexmann |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
numbers instead of letters
Hi
ToolsoptionGeneraluntick R1C1 reference style -- Regards Roger Govier "rexmann" wrote in message ... Hi all (Excel 2002) A colleague of mine was working on a spreadsheet and while working on it the columns which are normally letters have changed to numbers!! So now there is rows and columns in numbers (no letters). They do not remember pressing anything (or at least they ain't admitting it!). Can anyone help me put it back to normal? Any help greatly appreciated Kind regards Rexmann |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
numbers instead of letters
<tools<options unselect R1C1 reference style
This happens often enough that it may be sensitive to power surges or something, or a file set like this may have been opened , I can easily believe they did nothing unusual when it happened. "rexmann" wrote: Hi all (Excel 2002) A colleague of mine was working on a spreadsheet and while working on it the columns which are normally letters have changed to numbers!! So now there is rows and columns in numbers (no letters). They do not remember pressing anything (or at least they ain't admitting it!). Can anyone help me put it back to normal? Any help greatly appreciated Kind regards Rexmann |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
numbers instead of letters
Hi
Thanks for both answers - much appreciated by me and colleague Cheers Rexmann "bj" wrote: <tools<options unselect R1C1 reference style This happens often enough that it may be sensitive to power surges or something, or a file set like this may have been opened , I can easily believe they did nothing unusual when it happened. "rexmann" wrote: Hi all (Excel 2002) A colleague of mine was working on a spreadsheet and while working on it the columns which are normally letters have changed to numbers!! So now there is rows and columns in numbers (no letters). They do not remember pressing anything (or at least they ain't admitting it!). Can anyone help me put it back to normal? Any help greatly appreciated Kind regards Rexmann |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
numbers instead of letters
"Roger Govier" wrote: Hi ToolsoptionGeneraluntick R1C1 reference style -- Regards Roger Govier "rexmann" wrote in message ... Hi all (Excel 2002) A colleague of mine was working on a spreadsheet and while working on it the columns which are normally letters have changed to numbers!! So now there is rows and columns in numbers (no letters). They do not remember pressing anything (or at least they ain't admitting it!). Can anyone help me put it back to normal? Any help greatly appreciated Kind regards Rexmann I wanted to do the opposite so I was helped as well thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I chang numbers to letters on Excell forumal bar? | Excel Discussion (Misc queries) | |||
| Sorting - cells containing numbers, numbers and letters | Excel Discussion (Misc queries) | |||
| Change the header columes back to letters not numbers | New Users to Excel | |||
| Converting letters to numbers | Excel Worksheet Functions | |||
| How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
