ExcelBanter - Excel

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

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

- - Excel (https://www.excelbanter.com/excel-worksheet-functions/12653-excel.html)

Sawdust

Excel

Why is a decimal point appearing in a column of cells on my spreadsheet and
how do I get ride of it?

JE McGimpsey

Format the column as "General"?

In article ,
"Sawdust" wrote:

Why is a decimal point appearing in a column of cells on my spreadsheet and
how do I get ride of it?

Gord Dibben

Saw

Do you get 1.23 when you enter 123?

ToolsOptionsEdit. Uncheck "Fixed Decimal Places".

Gord Dibben Excel MVP

On Fri, 11 Feb 2005 02:13:02 -0800, "Sawdust"
wrote:

Why is a decimal point appearing in a column of cells on my spreadsheet and
how do I get ride of it?

All times are GMT +1. The time now is 12:06 AM.