dollar amounts
 

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?

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" wrote in message ...
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?

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?

need to add decimal points to it.....

I got a lot of my begginer help on this site... cool


they teach you by making a,

time sheet, Invoice and cheek book from scratch on Windows media Player
very cool


www.MDOTutorials.com


--
Route2391
------------------------------------------------------------------------
Route2391's Profile: http://www.excelforum.com/member.php...o&userid=26774
View this thread: http://www.excelforum.com/showthread...hreadid=397847