settings

B

Bee

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
 
J

Jason Morin

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

HTH
Jason
Atlanta, GA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Slideshow with black border around it 1
Cell data entering slow! 0
Bugs in Office 2019 0
Extracting just the time portion 6
Cannot access to Office Insider 0
List all tables, including document structure 0
Need help creating a running subtotal 2
Can't save my Office documents (after computer rebuild and reauthorization) 0

Top