Use Tools | Options |General and put check in top left box "R1C1 reference
style"
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Frank Cao" <Frank wrote in message
...
It's awkward for me to use "A, B, ...CW..." as column names, when large
matrices of data are processed.

I couldn't find a way to change the column name convention in Excel to
regular numbers "1,2,3....", just as the convention of the row names.

Also, I could not find a good reference book, or online reference
document,
describing how to rely on numerical references to worksheet locations
during
large matrices manipulations. All references I have found a based on
"mouse,
click, drag...", which are very impractical for large matrices operation.