ExcelBanter - trailing 0's when formating is for no decimals

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

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

- - trailing 0's when formating is for no decimals (https://www.excelbanter.com/excel-worksheet-functions/8517-trailing-0s-when-formating-no-decimals.html)

DaveM

trailing 0's when formating is for no decimals

I have formatted the cell as number with thousand seperator and no decimals.
Yet to get 90,000 in a formula I have to put in 9000000. If I don't add the
zero's, Excel uses 2 decimals and rounds the number.

Frank Kabel

Hi
goto 'Tools - Options - Edit' and uncheck 'fixed decimals'

--
Regards
Frank Kabel
Frankfurt, Germany

DaveM wrote:
I have formatted the cell as number with thousand seperator and no
decimals. Yet to get 90,000 in a formula I have to put in 9000000. If
I don't add the zero's, Excel uses 2 decimals and rounds the number.

Jerry W. Lewis

Tools|Options|Edit and uncheck "Fixed decimal Places"

Jerry

DaveM wrote:

I have formatted the cell as number with thousand seperator and no decimals.
Yet to get 90,000 in a formula I have to put in 9000000. If I don't add the
zero's, Excel uses 2 decimals and rounds the number.

All times are GMT +1. The time now is 04:21 AM.