Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can not format cells
Hi all,
I am using a spreadsheet created by someone else. I am using Excel2K on Win2k. I want to format a certain column as date. When I click "Format:Cells", nothing happens. I can use the currency, percent, decimal incr/dec or any other format toolbar button, and the format of the cell will change. Neither the sheet nor workbook are protected, and there is no code in the VBE. If I insert a new sheet in the workbook, I get the same behaviour. If I open a new workbook, everything is OK and I can format the cells. Any ideas? Thanks for the help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can not format cells
Is it possible that the previous user applied a style to the workbook? -- BruceP ------------------------------------------------------------------------ BruceP's Profile: http://www.excelforum.com/member.php...o&userid=33653 View this thread: http://www.excelforum.com/showthread...hreadid=534273 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can not format cells
Thanks for the hint Bruce. I did find that the cells had a style attached to
them, but even after I returned the cell to "Normal" style I was unable to get the "Format:Cells" command to work. I didn't find anything on a style defined at the workbook level. Thanks again. "BruceP" wrote: Is it possible that the previous user applied a style to the workbook? -- BruceP ------------------------------------------------------------------------ BruceP's Profile: http://www.excelforum.com/member.php...o&userid=33653 View this thread: http://www.excelforum.com/showthread...hreadid=534273 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why will my cells not format? | New Users to Excel | |||
How can I find and format specific cells automatically in Excel? | Excel Worksheet Functions | |||
Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
format cells dialog box does not come up | Excel Discussion (Misc queries) |