Number Formats

E

Erika

I have imported a spreadsheet into to excel - the
spreadsheet contains a column of dollar amounts however if
the dollar amount is just cents. It is displays as 30｢ -
how do I change the to say $.30?
 

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

Mail Merge Switch - Dollars to Words 0
converting number to dollar 10
Add additional information to excel form after original data entry 0
sum columns only if date 5
Formula Using Vlookup & Match 3
Data Look Up 2
converting number to dollar 1
Using Text to Columns with a function 6

Top