numbers automatically populate in red
 

I am trying to create a formula, when a debit is entered, the numbers with in
the field will automatically populate in red with the brackets

numbers automatically populate in red
 

When you format the debit cells the format options should give you the choice
of bracketed red numbers.
--
Thank you for your help.


"ekornell" wrote:

I am trying to create a formula, when a debit is entered, the numbers with in
the field will automatically populate in red with the brackets

numbers automatically populate in red
 

Red and brackets indicates a negative number in some numeric formats so this
is as it should be... but you can change if desired, from the format cells
dialog box.

"ekornell" wrote:

I am trying to create a formula, when a debit is entered, the numbers with in
the field will automatically populate in red with the brackets

numbers automatically populate in red
 

When you inter the numbers in the cell, formated for red negative bracketed
numbers, inter the numbers as negative, i.e. -x, and they should appear as
red bracketed numbers. In the formula inter the cell as +C2 (or whatever the
cell is).
--
Thank you for your help.


"Sam Carraway" wrote:

When you format the debit cells the format options should give you the choice
of bracketed red numbers.
--
Thank you for your help.


"ekornell" wrote:

I am trying to create a formula, when a debit is entered, the numbers with in
the field will automatically populate in red with the brackets

numbers automatically populate in red
 

enter (dyslexic)
--
Thank you for your help.


"Sam Carraway" wrote:

When you format the debit cells the format options should give you the choice
of bracketed red numbers.
--
Thank you for your help.


"ekornell" wrote:

I am trying to create a formula, when a debit is entered, the numbers with in
the field will automatically populate in red with the brackets