| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display a number as a decimal
I would like to aded custom formatting to allow me to enter a number in a
cell (ie 25) and have it display as 0.25. Can anyone help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display a number as a decimal
Go to Tools--Options--Edit and select Fixed decimal and enter the
appropriate number, which in your case is 2. Click OK and then you should be set. -- Brevity is the soul of wit. "Karen" wrote: I would like to aded custom formatting to allow me to enter a number in a cell (ie 25) and have it display as 0.25. Can anyone help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display a number as a decimal
Right-click on the cell(s) FormatCells NumberTab Custom type in the
window "."# ok hth Vaya con Dios, Chuck, CABGx3 "Karen" wrote: I would like to aded custom formatting to allow me to enter a number in a cell (ie 25) and have it display as 0.25. Can anyone help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting the number of decimal places for a text box. | Excel Discussion (Misc queries) | |||
| display total above certain number and display | Excel Discussion (Misc queries) | |||
| Cannot a change a number 10.0 to 10 , cannot take out the decimal | Excel Discussion (Misc queries) | |||
| Display a number as Kilometers and k/hr & as Time | Excel Discussion (Misc queries) | |||
| How do I display an insignificant 0 at the beginning of a number | Excel Discussion (Misc queries) | |||
Linear Mode
