A Concatenate formula I use inserts a number in text to create something simliar to the following: Cost of twelve gross wigets total $2967.56 and freight is included. It works find, but I would like to have the numbers formatted as such: $2,967.56...I have tried many ways to do this with a formula...will I have to use VB?
Thanks before hand.
Thanks before hand.