Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
keeping track of total dollar amount for campers | Excel Discussion (Misc queries) | |||
How do I align numbers where one number has a dollar sign? | Charts and Charting in Excel | |||
How can I sum only amounts that are in BOLD format within a column | New Users to Excel | |||
Dollar Bill Chart | Charts and Charting in Excel | |||
sumproduct to add total amounts for the month | Excel Worksheet Functions |