If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I sum an IIF function in an Access Report? | Ryan G | Setting Up & Running Reports | 20 | August 18th, 2005 06:41 PM |
Access Rounding Dollar Amounts Up When Not Wanted | dev513 | New Users | 2 | March 18th, 2005 02:47 PM |
How do merge letter with different dollar amounts in word | BREADBASKET | Mailmerge | 2 | November 11th, 2004 04:28 PM |
Round dollar amounts | Windowgirl | Worksheet Functions | 7 | January 28th, 2004 10:39 PM |
rounding dollar amounts | Dave | Worksheet Functions | 2 | November 1st, 2003 03:32 PM |