How to get number cell formatted as string?

[CryptOrchid]

I have a cell that is a double with a number of decimal spaces and negative numbers represented by parenthesis around the number.

In vba code, I want to get a string with the same formatting the end user is seeing. Any way to do that and not have to create the formating on my own?

Thanks
CryptOrchid