cells and numbers - need help soon PLEASE!
 

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.


--
prstlk
------------------------------------------------------------------------
prstlk's Profile: http://www.excelforum.com/member.php...o&userid=34638
View this thread: http://www.excelforum.com/showthread...hreadid=544072

cells and numbers - need help soon PLEASE!
 

Try this:

<Tools <Options <Edit tab,
And *UNCHECK*
"Fixed Decimal"

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"prstlk" wrote in
message ...

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.


--
prstlk
------------------------------------------------------------------------
prstlk's Profile:
http://www.excelforum.com/member.php...o&userid=34638
View this thread: http://www.excelforum.com/showthread...hreadid=544072

cells and numbers - need help soon PLEASE!
 

Tools Options EditTab uncheck the box "Fixed Decimal"

Vaya con Dios,
Chuck, CABGx3


"prstlk" wrote in
message ...

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.


--
prstlk
------------------------------------------------------------------------
prstlk's Profile:
http://www.excelforum.com/member.php...o&userid=34638
View this thread: http://www.excelforum.com/showthread...hreadid=544072

cells and numbers - need help soon PLEASE!
 

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 a
log of time today.

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


--
prstlk
------------------------------------------------------------------------
prstlk's Profile: http://www.excelforum.com/member.php...o&userid=34638
View this thread: http://www.excelforum.com/showthread...hreadid=544072

cells and numbers - need help soon PLEASE!
 

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!
==============================================

"prstlk" wrote in
message ...

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 a
log of time today.

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


--
prstlk
------------------------------------------------------------------------
prstlk's Profile:
http://www.excelforum.com/member.php...o&userid=34638
View this thread: http://www.excelforum.com/showthread...hreadid=544072