Excel 2003

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

Guest

How do I get "1.9" to show as "1" instead of "2".

Excel always rounds the number to nearest integer.

Is there anyway of Truncating it. Can you use the TRUNC formula in a format
so something?
 
Take a look at =rounddown() in excel's help.
How do I get "1.9" to show as "1" instead of "2".

Excel always rounds the number to nearest integer.

Is there anyway of Truncating it. Can you use the TRUNC formula in a format
so something?
Click to expand...
 
Thanks Dave,

The problem is I need the number and the formula in the same cell. But if I
input the the number then it overwrites the formula.

Do you think I need one input sheet with all the numbers and another output
sheet with all the formulas?

Dave Peterson said:
or =int(a1)
or =floor(a1,1)
or =trunc(a1)
Click to expand...
 
I don't usually use multiple sheets. But you can if you want.

You may want to just use an additional column.

Column A holds the user input
column b holds the formula (and is used in any subsequent formulas)
Thanks Dave,

The problem is I need the number and the formula in the same cell. But if I
input the the number then it overwrites the formula.

Do you think I need one input sheet with all the numbers and another output
sheet with all the formulas?
Click to expand...
 
Back
Top