formatting cells

P

pat67

Hi, I am trying to format cells that contain dollars in millions and
make it decimal. i.e $1,500,000 would show $1.5 and the head of the
table would say "Dollar Value in Millions" any ideas? Thanks
 

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

Excel does not accept text format! 0
Preserving trailing zeros for a fixed width file 0
Convert number to text as displayed 4
Selecting the first sentence of multiple paragraphs in Word 2007 2
auto sum column containing words and numbers 3
Formula that will increase an integer added to a value based on.. 0
How do I automatically convert $1,234,555,678.05 to $1.5 billion? 2
Formula Using Vlookup & Match 3

Top