Formatting Cells

  • Thread starter Thread starter Lyle Brambier
  • Start date Start date
L

Lyle Brambier

I have been having a problem lately when I try to format a group of cells. I
need to change them to Short Date format, but when I click on a group of
cells and either right click and select format or if I try the Ctrl+1 combo
to bring up the format menu nothing happens. On other occasions it works. Is
this a known bug? Any known way of solving this so it works all the time?
Thanks! Lyle
 
If Lori's response doesn't apply:

The only time I've seen this is when the workbook was created by another program
(Lotus 123 and Crystal Reports, for me).

I could select a little bigger range and get the dialog to appear. Then I'd
format this larger range and come back later to change the sacrificial cells
back to what they should be.

Any chance your workbook was created by something else?
 
You must log in or register to reply here.

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

Conditional formatting in Excel 2010 2
I can't format cells 2
Format cells dialog 3
Excel Highlighting duplicates 0
Remove date format? 3
Excel Macro to automatically go to the right of the last colored cell 0
Cell Format 1
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2

Back
Top