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
|