How to get number cell formatted as string?

C

CryptOrchid

Joined
Sep 5, 2009
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatted Number into String Variable, Excel VBA 3
Display entire number in cell 3
How do you count the number of * in a string? 5
concatenate text and formatted cell 2
Using functions in string formatted cells 4
find and scroll to cell string value in Excel 2
Formatting 8
adding a cell in a text string 8

Top