| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
when i enter a price like 16.50 the zero get cut off 16.5
how do i keep the zero on the price sheet using excel. $16.50
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
when i enter a price like 16.50 the zero get cut off 16.5
|
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
when i enter a price like 16.50 the zero get cut off 16.5
Pre-format the cell to 2 decimal places.
FormatCellNumberNumberDecimal Places..2 Gord Dibben MS Excel MVP On Sun, 15 Oct 2006 15:57:01 -0700, . com wrote: how do i keep the zero on the price sheet using excel. $16.50 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
when i enter a price like 16.50 the zero get cut off 16.5
....and note that you do not need to type the final zero. Enter 16.5 to get
16.50 best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Pre-format the cell to 2 decimal places. FormatCellNumberNumberDecimal Places..2 Gord Dibben MS Excel MVP On Sun, 15 Oct 2006 15:57:01 -0700, . com wrote: how do i keep the zero on the price sheet using excel. $16.50 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is there a way to enter data interactively and dynamically? | Excel Discussion (Misc queries) | |||
| how to enter negative amounts in the unit price column of excel | Excel Worksheet Functions | |||
| Return a price based on a customer from a drop down list | Excel Discussion (Misc queries) | |||
| How do I formulate a high price column | Excel Discussion (Misc queries) | |||
| Is there a (non-binary) "if x then enter y" forumula? | Excel Worksheet Functions | |||
Linear Mode
