Can you give an example or two?
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Lyd" wrote in message
...
12 digit number entered with cell formatted as just a number is rounding
to
end in zero all the time. Help please. cell is not locked