Just two places...like an adding machine

[the5barrons]

How do I get Excel 2007 to automatically place two decimal points in on any number I place in the cell?

For instance, if I enter 1345 in the cell, I want it to automatically correct it to 13.45. Not 1345.00.

Or..If I type in 35, I want it to correct it to 0.35, not 35.00.

I have tried every function in the program (I think)...not to mention I've looked for every youtube vid known and there isn't anything about this. Only how to make decimal places vary...which I already know.

Thanks for any help.

-Andy

***EDIT...I use excel to calculate tax info and I input all my receipt data...total on one row and sales tax on the other. I just want those rows to be able to have me write in the full number without having to hit the decimal key. I know it seems lazy, but when you input a few hundred receipts, every little bit counts. Lol.

[the5barrons]

Nothing in the search on this forum for this cell format issue. Anyone? EF Hutton?

[Charlie_Howell]

I'm not sure its possible but there are some work-arounds...here's one way.

[the5barrons]

I'm not sure its possible but there are some work-arounds...here's one way.

Thanks, yeah...I'm beginning to see that it might not be possible, but if you can get column B to produce the right format from column A, why can't excel just make that happen directly without the formula conversion? Seems pointless to have the extra step. I guess I'll keep experimenting.

[Charlie_Howell]

This is the second way

[ChemistB]

Set your excel options>advanced>Editing Options>Automatically insert a decimal point at 2 places.
Is that what you are looking for?

[Charlie_Howell]

Hey! that works! I forgot about that little thing....lol

[the5barrons]

Set your excel options>advanced>Editing Options>Automatically insert a decimal point at 2 places.
Is that what you are looking for?

I'm so sorry but I don't even have an Editing Options spot to go to. On 2007, the panes don't have that drop down. I don't even see anything for advanced.

[Charlie_Howell]

look at the top left corner...the Microsoft globe..click that thing

[the5barrons]

Found it. right click on the Office sign...duh

[the5barrons]

That got it. Thank y'all. That issue has been a work around for me for well....6 years. That'll make life a lot easier. Appreciate it.