silentcoates
New Member
- Joined
- Oct 11, 2005
- Messages
- 41
Hello
If I have a list of monetay amounts in a list in column A and some of them have a capital C after them. Is there a formula that will change these ones so they show as a negative amount without the C and in red. Example below
A B
10.20C -10.20
Thanks for any help you can offer.
If I have a list of monetay amounts in a list in column A and some of them have a capital C after them. Is there a formula that will change these ones so they show as a negative amount without the C and in red. Example below
A B
10.20C -10.20
Thanks for any help you can offer.