How to skip the rounding function of a cell

  • Thread starter Thread starter Jon
  • Start date Start date
J

Jon

Hi all

Got a annoying problem, if I type in
17,7765 into a cell

I want to show all numbers with two decimals
17,77

The problem is when I change to two decimals it rounds off the number
too 17,78

Can I suppress the function?
 
Hi Don

It does'nt work
btw I got office 2000 sp3


Mvh
Jon
(e-mail address removed)
 
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

Rounding numbers 3
Automatic rounding and placement of decimals. 1
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
Rounding 6
How do I round off a number to 333.00 instead of 332.84? 3
ROUND 2
problem with round down 5
add rounded numbers using the rounded value 2

Back
Top