Thread: HOW DO I UNDISPLAY FRACTIONS?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default HOW DO I UNDISPLAY FRACTIONS?
Maybe FormatCellsNumber to 0 decimal places?

Or maybe =INT(A1)


Gord Dibben MS Excel MVP

On Sat, 22 Sep 2007 13:46:01 -0700, kim wrote:

i just want to display a whole number coming from other cell to another..

Reply With QuoteReply With Quote