I can't format my cells. It is number cells which I want to round out. The sheet is unprotected.
P Paul Feb 9, 2005 #1 I can't format my cells. It is number cells which I want to round out. The sheet is unprotected.
E Earl Kiosterud Feb 9, 2005 #2 Paul, Is it shared? Look at Tools - Share workbook. "Allow changes by more than one user...." should not be checked.
Paul, Is it shared? Look at Tools - Share workbook. "Allow changes by more than one user...." should not be checked.
D Dave Peterson Feb 9, 2005 #3 I could change format on an unprotected worksheet in a shared workbook (xl2002). But I don't have a guess. To the Original Poster: What did you try (rightclicking Format|cells), Format|Cells), hitting the increase/decimal icon? And what happened when you did what you did??
I could change format on an unprotected worksheet in a shared workbook (xl2002). But I don't have a guess. To the Original Poster: What did you try (rightclicking Format|cells), Format|Cells), hitting the increase/decimal icon? And what happened when you did what you did??
