Tools | Options - Edit tab and uncheck Fixed Decimal Places
--
HTH...

Jim Thomlinson


"Reen" wrote:

Every time I put a number in a cell such as 1234, it comes out as 12.34 then
I have to format it to text to make it just 1234 and THEN change it to a
number, from the dropdown box that displays itself, I have tried changing the
decimal places and selecting "general" "number", etc. nothing works. Ido
Format cells - number - and in catagory - what do I pick?

Depends on the format of the cell you are entering in. Format | Cells -
Number and specify decimals and commas...
--
HTH...

Jim Thomlinson


"Reen" wrote:

Thank you so much! Also, I used to be able to put: ten decimal eg:10. and it
would appear as 10.00 now it doesn't do that, I realize it's a small thing
but I enter a lot of numbers and I don't know why I used to be able to do it
and now I can't. Thank you.

"Jim Thomlinson" wrote:

Tools | Options - Edit tab and uncheck Fixed Decimal Places
--
HTH...

Jim Thomlinson


"Reen" wrote:

Every time I put a number in a cell such as 1234, it comes out as 12.34 then
I have to format it to text to make it just 1234 and THEN change it to a
number, from the dropdown box that displays itself, I have tried changing the
decimal places and selecting "general" "number", etc. nothing works. Ido
Format cells - number - and in catagory - what do I pick?