Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Cell will not format

Right click on cells that were copied over from another excel sheet and can
not format the cell - right click - format does not work
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 506
Default Cell will not format

Check whether the Worksheet is protected.

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"jeanngoodyear" wrote:

Right click on cells that were copied over from another excel sheet and can
not format the cell - right click - format does not work

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Cell will not format

Right-clickformat cells does not show up or you cannot re-format the data?

What type of data are in the cells?

Maybe dates that are text?

Numbers that are text?


Gord Dibben MS Excel MVP

On Mon, 23 Nov 2009 20:43:02 -0800, jeanngoodyear
wrote:

Right click on cells that were copied over from another excel sheet and can
not format the cell - right click - format does not work


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lock Cell Format - Allow copy and paste of data without format change Chris12InKC Excel Worksheet Functions 2 May 9th 23 07:42 PM
cell format - remove cell format pattern without effecting colors Bas Excel Discussion (Misc queries) 1 March 23rd 09 02:54 PM
Can cell format come from and change with reference cell format jclouse Excel Discussion (Misc queries) 1 November 29th 06 03:20 AM
Custom Cell format to mimic time format [email protected] Excel Discussion (Misc queries) 6 November 7th 06 09:17 PM
How do I copy data in single cell format to a merged cell format Paul Excel Discussion (Misc queries) 1 June 27th 05 11:00 AM


All times are GMT +1. The time now is 04:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"