# example: 12.954; dynamically DELETE number after 'point'????

#### nescartel

##### New Member
let's say i have 12.954, how to delete numbers after decimal point so that i got 12 as the output? if i just format the cell to have integer values, it will automatically round the number to 13, which i don't want! any solutions?

### Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Is this the result of a formula? If so, try ROUNDDOWN(A1,0) or TRUNC(A1,0) or INT(A1).

You could also format the cells to round to the nearest whole number

WOW!!! THANX SETI!!! i've been searching the net for this solution, and i got it now!

Okay, how come when i apply ROUNDDOWN on 1.00 it appears to be 0?! supposed to be 1 right? can anyone help me here?

Okay, how come when i apply ROUNDDOWN on 1.00 it appears to be 0?! supposed to be 1 right? can anyone help me here?
The 1 may not actually be 1. Is it a number entered directly? Or the result of a formula? Try selecting the cell with 1 and format it to show more decimal places, you will most likely find that it is actually 0.96754 or something similar.

YUP! that does it!!! turns out the number is actually 0.9++ something. solved the problem by adding "+0.01" at the back of the roundup. THANX AGAIN!!! :wink:

Replies
8
Views
262
Replies
3
Views
110
Replies
10
Views
246
Replies
6
Views
159
Replies
9
Views
214

1,196,277
Messages
6,014,406
Members
441,818
Latest member
itsfaisalkhalid

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back