You have an answer elsewhere - please do not multi-post.

Pete

On Oct 29, 6:15 pm, adam wrote:
how do I make one cell postive or negative based on another cells contents.
For Example:

123.00 c
565.00 d
613.00 d

When I upload all numbers come up postive like shown above. How do I get it
so the 123.00/"c" row come up negative. I want all "c"/credits to come up as
a negative number.