Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel: How can I get numbers without decimals ?
After entering numbers in a cell they appear as decimals. I have tried going
into Format and changing it to 0 decimal but then I get 0. Can you please help me. |
#2
|
|||
|
|||
ToolsOptionsEdit, uncheck Fixed decimal
-- Kind Regards, Niek Otten Microsoft MVP - Excel "Wamalapada" wrote in message ... After entering numbers in a cell they appear as decimals. I have tried going into Format and changing it to 0 decimal but then I get 0. Can you please help me. |
#3
|
|||
|
|||
Hi -
It sounds like you have a default # of decimal places set in Options. Go to ToolsOptions & on the Edit page remove the check for Fixed Decimal Places. HTH |:) On 4/8/05 2:39 PM, in article , "Wamalapada" wrote: After entering numbers in a cell they appear as decimals. I have tried going into Format and changing it to 0 decimal but then I get 0. Can you please help me. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print tickets with incrementing numbers in Excel ? | Excel Worksheet Functions | |||
My Excel column headers have changed to numbers, how do I get bac. | Excel Discussion (Misc queries) | |||
Aligning decimals in Excel ... | Excel Discussion (Misc queries) | |||
How do I get Excel to correctly add a column of numbers that have. | Excel Discussion (Misc queries) | |||
How do i increase the size of numbers in a text in Excel. | Excel Worksheet Functions |