Paste values and Number format

[Guest]

In a file, I had a column set to have 1 decimal place. When I paste values
from another area, the formatting does not stay, but instead the number of
decimal places from the original spot is used. Even if I change the number
format afterward, it will not take.

If I type in a number in that cell, it will round to the correct decimal
place. If I create a new file, the number format works. This file has
conditional formatting, but if I remove it, the decimal place problem remains.

What else can I try to troubleshoot this?

 

[Frank Kabel]

Hi
maybe use
'Edit - Paste Special - Values'

 

[duane]

when you past the value in are you doing so via "paste special", values
or are you just pasting it in

 

[Guest]

I was doing a paste special/Vaules and still lose the formatting in this
file. If you go back to the format/number it shows the correct format, but
the cell does not.