Paste values and Number format

G

Gilbert C

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?
 
D

duane

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

Gilbert C

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