HEEEEELLLLPPPPP I've done something wrong

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
hi,
just a guess but try going to Tools>options>edit tab and uncheck fixed
decimal palces.

regards
FSt1
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Decimal Place goes crazy when using the "&" Sign. 4
Formatting zeros as dashes 4
Solver Problems 1
Custom Format - Show 12.5 but not 12.0 (drop .0s) ? 2
Excel decimal moving? 4
How do I prevent the cell from changing the number I enter? 2
Excel 2007 Conditional formatting with number formats 3
Excel 2007 adding a column of negative and positive number 2

Back
Top