View Single Post
  #3   Report Post  
K.S.Warrier
 
Posts: n/a
Default

Hi,
Suppose you have the number with decimals in cell A1.Then in B1 ,first
format the cell to 5 decimals & then,write
=if(mod(A1,1)=0,int(A1),A1) which will give you the desired result.This
may be repeated in other cells also.
Thank you,
K.S.Warrier

"crck_whr" wrote:

Is there a way to format a cell so that if you enter a whole number it stays
the way it was entered byt if you enter a decimal it gives the number five
decimal places? I have tried using general cell formatiing but this drops
zeros from the end and I need them to be displayed.