I want to insert a two decimal place in the cell automatically every time I
enter a number. For example, when I type 2345 in a cell, I want it to change
to 23.45
Is there anyway to format the cell with applying any formula?

Radha

In pre xl2007 I would goto toolsoptionsedit tab, and place a check mark in
"Fixed decimal" and set the "Places" to 2. Now if you enter 2345 you get
23.45. But remember if you want 250 and not 2.50 you must enter 25000.

Hope this helps

Mike Rogers


"Radha" wrote:

I want to insert a two decimal place in the cell automatically every time I
enter a number. For example, when I type 2345 in a cell, I want it to change
to 23.45
Is there anyway to format the cell with applying any formula?

Hi,

In 2007 the command is Office Button, Excel Options, Advanced, check
Automatically insert a decimal point (in the Editiong options area) and set
Places to 2.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Radha" wrote:

I want to insert a two decimal place in the cell automatically every time I
enter a number. For example, when I type 2345 in a cell, I want it to change
to 23.45
Is there anyway to format the cell with applying any formula?

Mike

But remember if you want 250 and not 2.50 you must enter 25000.

You can also enter 250 then a decimal point to return 250

The decimal point will be ignored.


Gord Dibben MS Excel MVP

On Wed, 4 Mar 2009 22:07:01 -0800, Mike Rogers
<Mike060349@NoxSpamxAOLDOTcom wrote:

In pre xl2007 I would goto toolsoptionsedit tab, and place a check mark in
"Fixed decimal" and set the "Places" to 2. Now if you enter 2345 you get
23.45.

Gord

You don't miss much, do ya. <bg I knew that but missed it!!!! thanks for
posting "the rest of the answer". I am sure the op appreciates it and I
definately do. (Cuz I hate "half an answer").

Thanks again

Mike Rogers

"Gord Dibben" wrote:

Mike

But remember if you want 250 and not 2.50 you must enter 25000.

You can also enter 250 then a decimal point to return 250

The decimal point will be ignored.


Gord Dibben MS Excel MVP

On Wed, 4 Mar 2009 22:07:01 -0800, Mike Rogers
<Mike060349@NoxSpamxAOLDOTcom wrote:

In pre xl2007 I would goto toolsoptionsedit tab, and place a check mark in
"Fixed decimal" and set the "Places" to 2. Now if you enter 2345 you get
23.45.

One less finger poke<g

Finger-poking is my method of typing.


Gord Dibben MS Excel MVP

On Thu, 5 Mar 2009 12:21:03 -0800, Mike Rogers
<Mike060349@NoxSpamxAOLDOTcom wrote:

Gord

You don't miss much, do ya. <bg I knew that but missed it!!!! thanks for
posting "the rest of the answer". I am sure the op appreciates it and I
definately do. (Cuz I hate "half an answer").

Thanks again

Mike Rogers

"Gord Dibben" wrote:

Mike

But remember if you want 250 and not 2.50 you must enter 25000.

You can also enter 250 then a decimal point to return 250

The decimal point will be ignored.


Gord Dibben MS Excel MVP

On Wed, 4 Mar 2009 22:07:01 -0800, Mike Rogers
<Mike060349@NoxSpamxAOLDOTcom wrote:

In pre xl2007 I would goto toolsoptionsedit tab, and place a check mark in
"Fixed decimal" and set the "Places" to 2. Now if you enter 2345 you get
23.45.

Thank you guys, I really appreciate your help.

Radha

"Radha" wrote:

I want to insert a two decimal place in the cell automatically every time I
enter a number. For example, when I type 2345 in a cell, I want it to change
to 23.45
Is there anyway to format the cell with applying any formula?