how to round up in exel to nerest cent

M

morefeus

Joined
Sep 30, 2009
Messages
2
Reaction score
0
I need to know how to round up in exel, i have in A1 to A100 alist of prices:
13.255
16.759
14.658
and so on, i need to round off this list of numbers to the cent:

13.26
16.76
14.66

I know there is an easy way to do this in exel spread sheet.
Please help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows XP In exel how do i 1
how to change formula into value exel cells 1
How do I get a calculated amount to round to the nearest nickel? 3
how do i mark up prices? 1
How to set a back ground picture in an exel file 2
how can i move from from sheet1 to sheet2 in the xl without mouse 2
exel help 4
Need formula to round number up to always end in X.X9 6

Top