hi,
just a guess but try going to Toolsoptionsedit tab and uncheck fixed
decimal palces.

regards
FSt1

"CC" wrote:

IF I put 1 in an Cell show Up 0.0001
I already went to Format Cell and choose decimal paces 0 and 1 and 2 etc and
still giv me 0.0001

I choose decimal places = 0 and I need Wright 3500.0 to Show up 3500
otherwise give 0.35

thanks in advance to anybody who attempt to give help