Computing.Net > Forums > Office Software > Excel Question, decimal point

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Excel Question, decimal point

Reply to Message Icon

Name: Old Salt
Date: February 5, 2006 at 04:04:09 Pacific
OS: Win2kPro
CPU/Ram: P4-3.2/512
Comment:


Win 2k pro Word 2000 Pro.
I must have doe something wrong because when I type a number into a cell it's didpalayed wrong, if I type in 10 it displays 0 [0.10] in the formula bar.

Can someone please tell how to set this up the way it was, IE, type in 10 display 10 not 0.10.

many thanks.

Avagoodweekend......



Sponsored Link
Ads by Google

Response Number 1
Name: rhawk7938
Date: February 5, 2006 at 10:27:37 Pacific
Reply:

Have you checked the cell number formatting??


0

Response Number 2
Name: Old Salt
Date: February 5, 2006 at 14:04:53 Pacific
Reply:

Cell format is set for number with 2 decimal places, the display is the same if I change the setting to zero decimal places?

Avagoodweekend......


0

Response Number 3
Name: Old Salt
Date: February 9, 2006 at 04:49:00 Pacific
Reply:

Resolved.
Tools>
Options> edit>
unchecked fixed decimal points..

Avagoodweekend......


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Excel Question, decimal point

excel question www.computing.net/answers/office/excel-question/7647.html

Date Formula in Excel 2002 www.computing.net/answers/office/date-formula-in-excel-2002/1555.html

Adding only visible value www.computing.net/answers/office/adding-only-visible-value-/6010.html