.xls Cell Format

G

Guest

In the last couple off weeks, a change? has caused Cell>Format>general to
default to 2 decimals. Cannot be changed. What has happened. How to fix.
'Text' format not an option.
 
G

Guest

Check tools>options>Edit tab and uncheck fixed decimals
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 

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

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Spam 4
Excel Excel 2007 won't stop rounding down my formula results! 5
format axis number - bug? 4
Excel Stop Excel from displaying rounded values 4
General Format altered/corrupted? 1
Peculiar default cell format 1
Excel format in selected cells have changed to DATE format!!!! 2

Top