| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I change column numbers back to column letters?
I'm using Office 2000. The columns are normally letters. When using the
command COLUMN(CB7), naturally I get the answer "80". How can I convert it back to "CB"? Someting like COMMAND(80) will equal "CB". I can't use CHAR(64+80) because that would not result in multiple letter column. Any help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My Excel column headings were letters and it switched to numbers? | Excel Discussion (Misc queries) | |||
| How do I change column labels from numbers to letters? | Excel Discussion (Misc queries) | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| how do i change column labels back to letters? currently columns. | Excel Discussion (Misc queries) | |||
| How do I change column labels from numbers to letters in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
