ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Entering numbers into a cell (https://www.excelbanter.com/excel-discussion-misc-queries/135260-entering-numbers-into-cell.html)

keestrokes

Entering numbers into a cell
 
I try to enter 10 and as I enter the 0 it replaces the 1. So instead of
seeing 10, I see only 0. I have tried every drop down but no luck.

Help!

Bob Phillips

Entering numbers into a cell
 
Check

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"keestrokes" wrote in message
...
I try to enter 10 and as I enter the 0 it replaces the 1. So instead of
seeing 10, I see only 0. I have tried every drop down but no luck.

Help!




Bob Phillips

Entering numbers into a cell
 
Goto ToolsOptions and on the Edit tab there is a checkbox for Fixed
Decimal. Uncheck that box.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"keestrokes" wrote in message
...
I try to enter 10 and as I enter the 0 it replaces the 1. So instead of
seeing 10, I see only 0. I have tried every drop down but no luck.

Help!





All times are GMT +1. The time now is 05:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com