Question

In Excel the numbers in our worksheet look like this: 1000. You want them to look like this: $1,000.00. How can you accomplish this?

Accepted Answer

Click the Currency Style button on the formatting toolbar

Answer

None of these

Answer

Select Format > Money from the menu

Answer

You have to retype everything and manually add the dollar signs, commas, and decimals.

Q. In Excel the numbers in our worksheet look like this: 1000. You want them to look like this: $1,000.00. How can you accomplish this?

Discusssion