Number formatting

  • Thread starter Thread starter Ket
  • Start date Start date
K

Ket

Hello,

A simple question I'm sure. If I have monetary amounts in a
spreadsheet for example 1,970,000, how can I automatically show the
figure as 1.97?

Many thanks.

Ket

PS Using Excel/Windows 2000
 
You must log in or register to reply here.

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

Data Filter and AutoSum 4
Simple Format Question 1
Excel Newbie...How To Re-Order Data 5
Displaying zeros in cells 2
Right Click disabled? 1
Access Running Balance in Access 1
Data Export 1
Format monetary amount to 9 digits with No decimals without rounding 4

Back
Top