Forum Discussion
Solved
Number formatting such that only the first number in the column has the $ sign
Dear Community, I am working on an excel file which contains numbers and NAs / NMs. While the number of rows in the table remains the same, the numbers the column and their position in the ta...
I believe if you select the range to format, and with the top left cell as the active cell (A1 in your example workbook), use a conditional format formula (change the cell reference as applicable):
=count(a$1:a1)=1
and select your custom number format.
I believe if you select the range to format, and with the top left cell as the active cell (A1 in your example workbook), use a conditional format formula (change the cell reference as applicable):
=count(a$1:a1)=1
and select your custom number format.
You are a genius! JMB17