| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| eliminate future zeroes | Charts and Charting in Excel | |||
| Can I set the default for "show zeroes" to not show the zeroes? | Setting up and Configuration of Excel | |||
| Leading Zeroes | Excel Discussion (Misc queries) | |||
| Leading Zeroes | Excel Discussion (Misc queries) | |||
| CSV leading zeroes | Excel Discussion (Misc queries) | |||
Hybrid Mode
