Round Up negative numbers

[Roger R]

I am importing data into an excel worksheet and some of
the numbers are negative. I would like to be able to
round them to zero with an easy formula. Any help would
be greatly appreciated.

Roger

 

[Frank Kabel]

Hi Roger
in an adjacent column enter
=MAX(A1,0)
if column A stores your values. Copy this formula down

 

[Aladin Akyurek]

Perhaps just:

=MAX(0,A1)