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.
 
Back
Top