![]() |
Can you eliminate zeroes
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 |
Can you eliminate zeroes
hi
yes. format the column to general. Regards FSt1 "JimS" wrote: 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 |
Can you eliminate zeroes
Uh, duh...thanks!
On Mon, 20 Apr 2009 16:18:04 -0700, FSt1 wrote: hi yes. format the column to general. Regards FSt1 "JimS" wrote: 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 |
All times are GMT +1. The time now is 04:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com