| Home |
| Search |
| Today's Posts |
|
#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. |
| 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) | |||
Threaded Mode
