How to make "("@")" work with =ROW()-1?
 

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.

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

How to make "("@")" work with =ROW()-1?
 

"Dave Peterson" wrote in message
...
@ 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, thank you once again for your help! This is so neat.

I didn't figure out how to make anything with the "row" formula work, though
that's probably me doing something wrong. But you're right re (General). I
never knew I could do that in Custom. One sees the "General" listed there
but I guess one thinks that it's like a default. Who'da thunk that
"(General)" would work. So I have "=ROW()-1" in the formula bar, and
"(General)" in the custom formatting for the cell and the display is (1),
(2), (3), etc. Perfect.

Thanks! :oD