dollar amounts

[acsnett]

When I enter dollar amounts how come the last zero, as in 18.50,
automatically deletes itself? It shows as 18.5. can anyone help me fix this
problem?

[David McRitchie]

You did get an answer to this in your other question see the
accounting formats under format, cells, accounting
also see the [$} [,] (comma) and [<- .0] [-> .0] buttons on the toolbar.-
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"acsnett" <acsnett@discussions.microsoft.com> wrote in message news:63D8780B-1628-4482-986A-BC0B2CB64A04@microsoft.com...
> When I enter dollar amounts how come the last zero, as in 18.50,
> automatically deletes itself? It shows as 18.5. can anyone help me fix this
> problem?

[Gary's Student]

Yes.

Before you type in your data, select the cells you are using for dollars and
pulldown

Format > Cells... > Number and select currency

Good Luck
--
Gary's Student


"acsnett" wrote:

> When I enter dollar amounts how come the last zero, as in 18.50,
> automatically deletes itself? It shows as 18.5. can anyone help me fix this
> problem?