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
 
Back
Top