View Single Post
  #1   Report Post  
crck_whr
 
Posts: n/a
Default cell that accepts a whole number or five place deciaml

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.