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

nescartel

New Member
Joined
Nov 21, 2005
Messages
4
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? :p
 

Seti

Well-known Member
Joined
May 19, 2002
Messages
2,916
Is this the result of a formula? If so, try ROUNDDOWN(A1,0) or TRUNC(A1,0) or INT(A1).
 
L

Legacy 51064

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

nescartel

New Member
Joined
Nov 21, 2005
Messages
4
WOW!!! :biggrin: THANX SETI!!! i've been searching the net for this solution, and i got it now! :LOL:
 

nescartel

New Member
Joined
Nov 21, 2005
Messages
4

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? :unsure:
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
41,709
Office Version
365
Platform
Windows
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.
 

nescartel

New Member
Joined
Nov 21, 2005
Messages
4
YUP! that does it!!! :LOL: 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:
 

Forum statistics

Threads
1,077,783
Messages
5,336,304
Members
399,074
Latest member
rlong98

Some videos you may like

This Week's Hot Topics

Top