View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How to make "("@")" work with =ROW()-1?

@ is the formatting symbol that makes the cell text.

I saw
(=row()-1)
when I entered the formula in a cell formatted that way.

But I could use a simple custom number format of:
(General)

and it looked ok.



StargateFanFromWork wrote:

How can we get numbers like (1), (2), (3), etc., when using "=ROW()-1"?

When entering alphanumeric characters manually, typing in 1, 2, 3, ..., in
cells formatted with "("@")", gives (1), (2), (3), etc. Trying do format
the cells in this way that use "=ROW()-1".

Thanks.


--

Dave Peterson