How to skip/remove decimal value from CONCATENATE?

[bhasoriya]

Hello all,

Good morning.


i have value 60.246 in one cell and another 32.045.

I have use decimal for both cell. i don't want value after .(point) so i have use here decrease decimal. so value is 60 & 32.


Now when i m using CONCATENATE to merge both the result is 60.24632.045.


How could i skip/remove value after .(point)


Thank you all..

 

[Hui]

Bhasoriya


A simple:

=Int(A1)&Int(A2)

will do the job


You can read the post here: http://chandoo.org/wp/2012/09/28/round-numbers-excel-formulas/

for other options for rounding up/down

 

[bhasoriya]

Thank Hui..


Thanks a lot..

 

[NARAYANK991]

Hi Bhasoriya ,


To add to what Hui has said , I think you need to understand why the formula is required.


When you format a cell to any format whatsoever , you are only changing the way the underlying value is displayed ; you can have a value like 1.2 in a cell , and you can format the cell to display the text YES.


For example , suppose I have the value 1.2 in A1 , format A1 using a Custom Format "YES";;; , Excel will display the text YES ; but if I have a formula in B1 =IF(A1="YES",A1,"NO") , B1 will display NO , since the contents of A1 are not the text string YES , but the numeric value 1.2


Narayan

 

[nazmul_muneer]

Dear bhasoriya,

A1=60.246 B1=32.045

Type the formula in C1=ROUNDDOWN(A1,0)&ROUNDDOWN(B1,0)


Regards,


Muneer

 

[shrivallabha]

Also FLOOR should work:

=FLOOR(A1,1)&FLOOR(A2,1)