View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Radha Radha is offline
external usenet poster
 
Posts: 6
Default Inserting decimal

I want to insert a two decimal place in the cell automatically every time I
enter a number. For example, when I type 2345 in a cell, I want it to change
to 23.45
Is there anyway to format the cell with applying any formula?