Can't change format of copied cells

  • Thread starter Thread starter xirx
  • Start date Start date
X

xirx

Hi!

I sometimes observe some strange behaviour, as follows:

I copy some cells containing numbers from one sheet
to another. But in the new sheet, these cells seem to
be text. When I select the pasted cells an assigm
these a number format, nothing changes: I need to
click into such a cell and press ENTER to get the
format change applied.

Any way to avoid this?
 
Hi

It sounds like the cells were formatted as text before you pasted the values
into them. Make sure they are formatted as General BEFORE you paste into
them. Another alternative is that the cells you copy are text - but they may
be right-aligned to appear like numbers.
To change a range of 'text' to numbers, copy a blank unused cell. Then
select your range and use Edit|Paste Special|Add
Andy.
 
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

Copying Row Code Doesn't Copy Conditional Formating 10
Copy and paste the cell boarder only not the content 3
Copy condtional formatting in XL2007 for Windows 1
VBA cell row formatting 5
copy parts of different cells into new cell 3
can't change cell format 3
Automatically chnage number format of a range of cells 2
Conditional formatting based on formula cell 6

Back
Top