Hi
I have a field that contains receipt numbers, most of which are numeric but a few commence with an alpha character such as "A12345". When the field starts with an alpha character I need to use conditional formatting to highlight the field.
Can anyone help me with an expression I can use in the conditional formatting to identify the situation above?
Appreciate your assistance..
I have a field that contains receipt numbers, most of which are numeric but a few commence with an alpha character such as "A12345". When the field starts with an alpha character I need to use conditional formatting to highlight the field.
Can anyone help me with an expression I can use in the conditional formatting to identify the situation above?
Appreciate your assistance..