answersLogoWhite

0

Use the TRUNC function. You can specify the value and the amount of decimal places you want.

=TRUNC(A2,1)

User Avatar

Wiki User

11y ago

What else can I help you with?

Related Questions

How do you Truncate 148.79 to the whole number?

148


What does truncate mean in math terms?

truncate means to add the whole number to whatever else you have,and then multiply it by your fraction


How to truncate the following number 3.8?

If you truncate 3.8, you will get 3. Remember, while truncating you don't have to follow the rules of rounding off.


What does it mean to give an approximate value of a number by reducing it to a specific number of digits?

truncate :)


How can you tell excel to ignore the third decimal place and beyond in calculations?

By use of the truncate function. For example: =TRUNC(B8,2) This will truncate cell B8 to two decimal places. Specifically, click the format button of a cell and input =trunc(<cell goes here>,<number of digits you want the decimal truncated to goes here>) Make sure there are no spaces in the syntax.


What is a sentence for the word truncate?

my brother can truncate my computer


Can you use commit statement after truncate?

You can use COMMIT any time, but it is not necessary after TRUNCATE TABLE.


What does the word 'truncate' mean?

Truncate has many meanings depending on how it is used in a sentence. If it is used as a verb, truncate means to shorten something. If used as an adjective it means it stopped suddenly.


Total number of column in Microsoft Excel?

The total number of columns in versions of Excel up to Excel 2003 is 256 columns. The total number of columns in Microsoft Excel 2007 and onwards is 16384. The total number of rows up to Excel 2003 is 65536. From Excel 2007 it is 1048576.


How would you use truncate in a sentence?

She had to truncate her story, so that it would fit into the five minute session.


What is the bottom number on Microsoft Excel?

The last row number for Excel 2007 is 1048576.


What is a number that can be entered into a cell on Excel?

Which of the following is a number that can be entered into a cell?