Windows XP In exel how do i

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
 
D

debs311

Joined
Oct 8, 2009
Messages
6
Reaction score
0
You can either choose the numbers tab and make it to 2 decimal places or you could do @round(cell,2)
 

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

how to round up in exel to nerest cent 0
how do I double or triple an existing EXEL file 11
Exel 2003 1
How do I Hide VBA excel sheets after saving 2
How do i obtain an add in called pause in exel? 3
how do i remove zeroes values from exel sheet 10
Exel Spread Sheet 7
how do I get rid of that "security warning" at top of Exel sheet 3

Top