Converting decimal values ​​to zeros

S

Special-K99

Well-known Member

Joined

Nov 7, 2006

Messages

8,511

Office Version

1. 2019

• Jul 17, 2014

• #2

Assuming columns are A and B

in B1
=INT(A1)
and copy down the column

 

Upvote 0

shimaa01234

Active Member

Joined

Jun 24, 2014

Messages

446

• Jul 17, 2014

• #3

Thank you very much
But if you want to keep the mark decimal and zeros

 

Upvote 0

P

pjmorris

Well-known Member

Joined

Aug 2, 2012

Messages

2,158

Office Version

1. 365

Platform

1. Windows

• Jul 17, 2014

• #4

follow Special-K99's instructions and then format the cell to have two decimal points.

 

Upvote 0

shimaa01234

Active Member

Joined

Jun 24, 2014

Messages

446

• Jul 17, 2014

• #5

Thank you Mr. "Special-K99"
Thank you Mr. "Pjmorris"

 

Upvote 0

V

vogel997

Active Member

Joined

Jan 22, 2010

Messages

412

• Jul 17, 2014

• #6

19.99	19.00	=ROUNDDOWN(A1,0)
18.01	18.00	=ROUNDDOWN(A2,0)
		another solution…

<colgroup><col width="64" style="width: 48pt;" span="2"> <col width="296" style="width: 222pt; mso-width-source: userset; mso-width-alt: 10825;"> <tbody> </tbody>

 

Upvote 0

P

pjmorris

Well-known Member

Joined

Aug 2, 2012

Messages

2,158

Office Version

1. 365

Platform

1. Windows

• Jul 17, 2014

• #7

my pleasure, thanks for the feedback.

 

Upvote 0

shimaa01234

Active Member

Joined

Jun 24, 2014

Messages

446

• Jul 17, 2014

• #8

Can you do it by code

 

Upvote 0

shimaa01234

Active Member

Joined

Jun 24, 2014

Messages

446

• Jul 17, 2014

• #9

Can you do it by code
Because I want to have been applying the same cell and not other cell
Sorry

 

Upvote 0

shimaa01234

Active Member

Joined

Jun 24, 2014

Messages

446

• Jul 17, 2014

• #10

UP

 

Upvote 0