ExcelBanter - HOW DO I UNDISPLAY FRACTIONS?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - HOW DO I UNDISPLAY FRACTIONS? (https://www.excelbanter.com/excel-worksheet-functions/159337-how-do-i-undisplay-fractions.html)

Kim

HOW DO I UNDISPLAY FRACTIONS?

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

Fred Smith

HOW DO I UNDISPLAY FRACTIONS?

You probably want to format the cell. Right click on the cell and choose Format
Cells...

--
Regards,
Fred

"kim" wrote in message
...
i just want to display a whole number coming from other cell to another..

Gord Dibben

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..

All times are GMT +1. The time now is 03:11 AM.