| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cells will not clear - if I type 1 it comes up as 100 know matter
I have tried everything to clear out the cells. Nothing is working. When I
do right click -- Format Cells -- Number -- Data it says that it is "General" and the sample says "100". I have no idea how to change the sample if that is what is required. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cells will not clear - if I type 1 it comes up as 100 know matter
ToolsOptionsEdit tab, uncheck Fixed decimal
-- Kind regards, Niek Otten Microsoft MVP - Excel "musicgirl" wrote in message ... I have tried everything to clear out the cells. Nothing is working. When I do right click -- Format Cells -- Number -- Data it says that it is "General" and the sample says "100". I have no idea how to change the sample if that is what is required. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cells will not clear - if I type 1 it comes up as 100 know matter
Niek - YOU ROCK!!!!! THANK YOU!!! THANK YOU!!! THANK YOU!!!
"musicgirl" wrote: I have tried everything to clear out the cells. Nothing is working. When I do right click -- Format Cells -- Number -- Data it says that it is "General" and the sample says "100". I have no idea how to change the sample if that is what is required. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding and grouping cells with similar subject matter | Excel Discussion (Misc queries) | |||
| Cells.Clear | Excel Discussion (Misc queries) | |||
| Every time I type 24-7 it changes to 24/Jul no matter what | Excel Discussion (Misc queries) | |||
| I get 0:00 when I format cells 4 time no matter what # I enter | Excel Worksheet Functions | |||
| how do I create floating cells so I can view them no matter wher. | Excel Discussion (Misc queries) | |||
Linear Mode
