numbers automatically populate in red

E

ekornell

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
 
S

Sam Carraway

When you format the debit cells the format options should give you the choice
of bracketed red numbers.
 
B

BoniM

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.
 
S

Sam Carraway

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).
 
S

Sam Carraway

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


Sam Carraway said:
When you format the debit cells the format options should give you the choice
of bracketed red numbers.
 
Top