View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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.