| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
change column name from letters to numbers?
I'm importing a 3rd party CSV file into Excel and then comparing some of
the contents to a printed spec. Each numbered field in the spec corresponds to a column in the work sheet. I'd like to change the column headers from letters to numbers. Is that possible? |
|
#2
|
|||
|
|||
|
Tools--Options, General tab. Check the R1C1 Reference Style.
******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Jerry" wrote in message ... I'm importing a 3rd party CSV file into Excel and then comparing some of the contents to a printed spec. Each numbered field in the spec corresponds to a column in the work sheet. I'd like to change the column headers from letters to numbers. Is that possible? |
|
#3
|
|||
|
|||
|
Thanks Anne.
-- Jerry Anne Troy wrote: Tools--Options, General tab. Check the R1C1 Reference Style. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Jerry" wrote in message ... I'm importing a 3rd party CSV file into Excel and then comparing some of the contents to a printed spec. Each numbered field in the spec corresponds to a column in the work sheet. I'd like to change the column headers from letters to numbers. Is that possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to find which numbers (3+) in a column sum to a value | Excel Discussion (Misc queries) | |||
| I cannot get a column of numbers to sum, why? | Excel Discussion (Misc queries) | |||
| I cannot get a column of numbers to sum, why? | Excel Worksheet Functions | |||
| Cannot get a column of numbers to SUM...why? | Excel Worksheet Functions | |||
| Change the width of a single column in a column chart | Charts and Charting in Excel | |||
Hybrid Mode
