Related Posts
My mind every time I meet new clients

Why do holidays when you can extend your impact

Additional Posts in Excel Genius
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.







I’d assume in a financial statement each line will be the same type of formatting. To get negatives in parenthesis you need to do a special format type in excel. When you open that menu you should see a formatting option that will give you this no problem. Easy google too
Exactly, you'll just need to create a custom Excel format but it should be easy enough to figure out.
because this is a financial statement and i dont want concatenation to cause formatting issues in the future. im sure theres a more simple formatting trick that im just not aware of
There might be a better way to do this, but why not use the an if statement with a concatenate function?