My sheet is unprotected, but I can't format cells.
I can't format my cells. It is number cells which I want to round out. The
sheet is unprotected. |
Paul,
Is it shared? Look at Tools - Share workbook. "Allow changes by more than one user...." should not be checked. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Paul" wrote in message ... I can't format my cells. It is number cells which I want to round out. The sheet is unprotected. |
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?? Earl Kiosterud wrote: Paul, Is it shared? Look at Tools - Share workbook. "Allow changes by more than one user...." should not be checked. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Paul" wrote in message ... I can't format my cells. It is number cells which I want to round out. The sheet is unprotected. -- Dave Peterson |
All times are GMT +1. The time now is 10:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com