P
P Atherton
TJ
You could use a conditional format if the number is less
than 0 to underline. But this underlines the whole cell.
Peter
and number length.
the beginning of the number format. However, I've got 2
problems:
number of " " added to it's beginning than 10,000. I
could create a Custom Style for each number length, but
I'm hoping to create one style that I can use for all
numbers that require this formatting.
kept together, I may be using font sizes anywhere from 7.5
to 12. I'd like to avoid having to make a style for each
font size. Or, would it be possible to write code that I
could use to update the formatting if a change in the font
size is necessary?
You could use a conditional format if the number is less
than 0 to underline. But this underlines the whole cell.
Peter
to the Accounting Number Format:
location of the currency symbol regardless of font size
and number length.
before the currency symbol by inserting multiple " " into
the beginning of the number format. However, I've got 2
problems:
numbers. Thus, the number 1,000 requires a different
number of " " added to it's beginning than 10,000. I
could create a Custom Style for each number length, but
I'm hoping to create one style that I can use for all
numbers that require this formatting.
different font sizes. In order to ensure all the data is
kept together, I may be using font sizes anywhere from 7.5
to 12. I'd like to avoid having to make a style for each
font size. Or, would it be possible to write code that I
could use to update the formatting if a change in the font
size is necessary?