| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sales Sheet
Hi Guys,
Really dumb question. Creating a basic spreadsheet to track sales. The majority of the cells are currency based except for the first one which would show a basic number without decimals (ie: 23). When I type in 23, it generates 0.23. How can I get rid of this so I can just have a basic # typed in there? Please help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sales Sheet
ToolsOptionsEdit.
Uncheck the "Fixed decimal places" option button. Gord Dibben MS Excel MVP On Sun, 2 Jul 2006 12:36:01 -0700, brettingsworth wrote: Hi Guys, Really dumb question. Creating a basic spreadsheet to track sales. The majority of the cells are currency based except for the first one which would show a basic number without decimals (ie: 23). When I type in 23, it generates 0.23. How can I get rid of this so I can just have a basic # typed in there? Please help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sales Sheet
ToolsOptions...ViewFixed decimals...un-check it
-- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "brettingsworth" wrote in message ... Hi Guys, Really dumb question. Creating a basic spreadsheet to track sales. The majority of the cells are currency based except for the first one which would show a basic number without decimals (ie: 23). When I type in 23, it generates 0.23. How can I get rid of this so I can just have a basic # typed in there? Please help. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sales Sheet
Thanks Gord. Told you it was something dumb. Thanks again.
"Gord Dibben" wrote: ToolsOptionsEdit. Uncheck the "Fixed decimal places" option button. Gord Dibben MS Excel MVP On Sun, 2 Jul 2006 12:36:01 -0700, brettingsworth wrote: Hi Guys, Really dumb question. Creating a basic spreadsheet to track sales. The majority of the cells are currency based except for the first one which would show a basic number without decimals (ie: 23). When I type in 23, it generates 0.23. How can I get rid of this so I can just have a basic # typed in there? Please help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup function and compare | Excel Discussion (Misc queries) | |||
| Need to look up value in another Sheet based on criteria in first sheet. | Excel Worksheet Functions | |||
| lock tab in sheet 2 until cell in sheet one is completed | Excel Worksheet Functions | |||
| Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Linear Mode
