Can you eliminate zeroes

J

JimS

I have a table with lots of percentages. One column might look like
this:

25.00
24.81
25.00
21.00
22.45
23.46

I type these in and they are not the results of formulas. Is there a
way to make the numbers that have a 0 or 00 fraction just show up as
the whole number so the table would look like this:

25
24.81
25
21
22.45
23.46

Thanks
 

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

Indirect & Match Formula Problem 1
Range Lookup 2
15 minute data to daily data 1
Problem entering numbers 3
linking multiple spreadsheets 0
re-allocation problem 1
Modifying a complex date formual to count months 4
Text Box troubles displaying text 2

Top