Deleting numbers after decimal point

[greekboyuk]

Hi I am trying to delete the numbers that follow the decimal point but I am struggling a bit. I have tried the replace ".*" option but it is joining the decimal not deleting it. For example :
A1 = 134.4678
A2 = 42.7777889
ect
I would like to be able to delete all the numbers after the decimal point so the outcome would be:
A1 = 134
B1 = 42
ect

Many thanks

[NBVC]

I just tried replacing .* with nothing and it worked fine.

Are the numbers hard-coded or formula results.

[greekboyuk]

hi, the numbers are hard coded. leaving it blank doesnt work either as it is not deleting the numbers after the decimal point but joining them together

thanks

[martindwilson]

works fine for me on either numbers or text numbers

[greekboyuk]

I don't know why is not working. I tried to simply enter a random number and it did work however on the sheet with the other numbers it doesn't. I was wondering whether is a different situation when the formatting is exported from the server as after the decimals I have noticed there is an invisible mb. So for example A1 is showing 1325.478843208 MB and the mb is not editable.

Thanks

[martindwilson]

what is the format of the cells?

[arthurbr]

Hi I am trying to delete the numbers that follow the decimal point but I am struggling a bit. I have tried the replace ".*" option but it is joining the decimal not deleting it.

Did you add the quotes? If so, delete them

[scottylad2]

34.4678 34
42.7777889 42
=LEFT(A1,FIND(".",A1)-1)+0 works and will leave you with numbers as opposed to text

[martindwilson]

still need to find where the mb is coming from
1325.478843208 MB
post a workbook with an example

[Richard Buttrey]

Hi,

Have you considered =INT(A1) in a helper column, copied down and then copy the whole helper column and paste back to A1 as special values?

Rgds

[greekboyuk]

Hi thank you Scottylad and Richard it worked perfectly. I figured out another way which you copy and paste values and use the "round".

I wasn't able to check the format of the cells as I couldnt go in "format cell" properties neither use shortcut "ctrl+1" the only thing that allowed me to do was copy "ctrl+c" .

Thank you very much for all your support

[martindwilson]

I wasn't able to check the format of the cells as I couldnt go in "format cell"

that begs the question ,why?

[KimHopkins]

You know the quickest way for this is:

=ROUND(A1,0)

Then just 'copy' and 'paste special' - values.

[shg]

Welcome to the forum, Kim.

ROUND and INT give different results.

[muso osum]

Best solution is first insert another column next your data you want to edit. go to the Data tab. Click TEXT TO COLUMN. Select the fixed space option. And put a line where you want the number to cutoff. finish. vwallah you have two columns. and everything after the fixed space is simply place in the next column which you can delete. Only way it worked for me.