ExcelBanter - settings

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

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

- - settings (https://www.excelbanter.com/excel-worksheet-functions/14453-settings.html)

Bee

settings

I have lost all of my previous settings and formulas in all excel spread
sheets. ie: I type the # 10 - it was set to displsy as 10.00 - now it shows
as .10. When I try to re-format the cells I choose 2 dicimal positions but
still get .10

Jason Morin

Uncheck the box "Fixed Decimal" found under Tools
Options Edit tab.

HTH
Jason
Atlanta, GA

-----Original Message-----
I have lost all of my previous settings and formulas in
all excel spread
sheets. ie: I type the # 10 - it was set to displsy as
10.00 - now it shows
as .10. When I try to re-format the cells I choose 2
dicimal positions but
still get .10
.

All times are GMT +1. The time now is 09:36 PM.