cells and numbers - need help soon PLEASE!

P

prstlk

I am new here so please be gentle!

I am a self taught Excel user and have what will be a pretty :confused:
question but here goes:

The only way my number entry will show in the cells is as though it
were a dollar amount - example:

I enter 2 and it shows 0.02 in the cell. How can I get this to change?
I have looked and tried tons of things and just get my workbook all
messed up.:eek: :eek: :eek:

Thank you for any help you can give me.
 
C

CLR

Tools > Options > EditTab > uncheck the box "Fixed Decimal"

Vaya con Dios,
Chuck, CABGx3
 
P

prstlk

Thank you to all who answered - I really appreciate it!

I have no idea how I got that one checked but you both have saved me
log of time today.

Again - thank you!!!:) :) :) :) :) :) :) :) :) :
 
R

Ragdyer

As to WHY and/or HOW it happened:
This option (fixed decimal), *as well as* the (manual - auto) calculate
option are determined per session, by the saved option of the *first* file
opened in that session.

See if this old post explains it to you:

http://tinyurl.com/anahg

--
HTH,


RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Top