Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CELL FORMAT
I want to format a column in excel 2003. I click on general because all I
want is a number. If I put the number 2 it shows .02. I do not want a decimal number. How do I change this so I just have any number without decimal. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CELL FORMAT
"mibes" wrote:
I want to format a column in excel 2003. I click on general because all I want is a number. If I put the number 2 it shows .02. I do not want a decimal number. How do I change this so I just have any number without decimal. Instead of General, use Number with zero decimal places. Note that this changes only the appearance of values in cells. The actual value will still be 0.02, for example. If you want to change the value itself, you need to use an appropriate round function; see the help pages for ROUND, ROUNDUP and ROUNDDOWN. For example, if A1 currently contains the formula =A2-A3, and you want the actual value to be rounded to an integer (no decimal fraction), change A1 to: =ROUND(A2-A3,0) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
CELL FORMAT
Toola/Options/Edit tab, deselect "Fixed Decimal Places"
Bob Umlas Excel MVP "mibes" wrote in message ... I want to format a column in excel 2003. I click on general because all I want is a number. If I put the number 2 it shows .02. I do not want a decimal number. How do I change this so I just have any number without decimal. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
CELL FORMAT
Is this happening only in the column you formatted or in any cell in the
worksheet? If the latter, click Tools/Options on the menu bar, select the Edit tab on the dialog box that appears and remove the check mark from the CheckBox labeled "Fixed decimal" -- Rick (MVP - Excel) "mibes" wrote in message ... I want to format a column in excel 2003. I click on general because all I want is a number. If I put the number 2 it shows .02. I do not want a decimal number. How do I change this so I just have any number without decimal. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
CELL FORMAT
Errata....
"Mibes" wrote: If I put the number 2 it shows .02. Disregard my response. I misread the OP. Fortunately Bob and Rich read better than I did ;). ----- original message ----- "JoeU2004" wrote in message ... "mibes" wrote: I want to format a column in excel 2003. I click on general because all I want is a number. If I put the number 2 it shows .02. I do not want a decimal number. How do I change this so I just have any number without decimal. Instead of General, use Number with zero decimal places. Note that this changes only the appearance of values in cells. The actual value will still be 0.02, for example. If you want to change the value itself, you need to use an appropriate round function; see the help pages for ROUND, ROUNDUP and ROUNDDOWN. For example, if A1 currently contains the formula =A2-A3, and you want the actual value to be rounded to an integer (no decimal fraction), change A1 to: =ROUND(A2-A3,0) |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
CELL FORMAT
Thanks worked fine. didn't know that tab existed.
"Bob Umlas" wrote: Toola/Options/Edit tab, deselect "Fixed Decimal Places" Bob Umlas Excel MVP "mibes" wrote in message ... I want to format a column in excel 2003. I click on general because all I want is a number. If I put the number 2 it shows .02. I do not want a decimal number. How do I change this so I just have any number without decimal. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
CELL FORMAT
Thanks worked fine. didn't know that tab existed.
"Rick Rothstein" wrote: Is this happening only in the column you formatted or in any cell in the worksheet? If the latter, click Tools/Options on the menu bar, select the Edit tab on the dialog box that appears and remove the check mark from the CheckBox labeled "Fixed decimal" -- Rick (MVP - Excel) "mibes" wrote in message ... I want to format a column in excel 2003. I click on general because all I want is a number. If I put the number 2 it shows .02. I do not want a decimal number. How do I change this so I just have any number without decimal. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
cell format - remove cell format pattern without effecting colors | Excel Discussion (Misc queries) | |||
Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
how do i format a cell based on format of a range of cells? | Excel Discussion (Misc queries) | |||
How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) |