View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default How do i change column header from R[1] C format to A1 format?

Hi,

Tools|Options - general tab and uncheck R1C1
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"lovnlife" wrote:

I am not sure how to get the worksheet to show alpha in the columns and
formulas instead of numeric.