ExcelBanter - Display a number as a decimal

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Display a number as a decimal (https://www.excelbanter.com/excel-discussion-misc-queries/107720-display-number-decimal.html)

Karen

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.

Dave F

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.

CLR

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.

All times are GMT +1. The time now is 02:31 AM.