In excel 2003 we could go to customise and a new tool bar . How do we do it
in excel 2007.


in excel 2003 we could go to options and fix the no of decimals . How do we
do it in excel 2007?

please give step by step instruction

Hi
I am on XP but I should imagine the following will work:
highlight all the cells you wish to change the decimal place settings for.
click on the 'format' drop down menu
chose the 'cells' option from the drop down list
click on the 'number' tab at the top of the window that appears
in the 'category' box in the left of the window chose 'number.
in the left of the window you will see that you can change the decimal
places you need.
Hope this helps.

"vinay kumra" wrote:

In excel 2003 we could go to customise and a new tool bar . How do we do it
in excel 2007.


in excel 2003 we could go to options and fix the no of decimals . How do we
do it in excel 2007?

please give step by step instruction

Microsoft has decided that some of its users are not savvy enough to handle
custom toolbars, therefore nobody gets them anymore. However, there is this
shadow of a toolbar called the QAT (Quick Access Toolbar) which you can add
controls to. Right click on a control and choose Add To Quick Access
Toolbar.

If you're not scared to learn some XML coding, you can create a new custom
tab for your ribbon. See Ron de Bruin's site:
http://www.rondebruin.nl/ribbon.htm

For the decimal places, click on the big ugly round Office button in the top
left, click on Excel Options, click on Advanced, under Editing Options,
click in the Automatically Insert a Decimal Point box, and enter the number
of digits you want.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"vinay kumra" <vinay wrote in message
...
In excel 2003 we could go to customise and a new tool bar . How do we do
it
in excel 2007.


in excel 2003 we could go to options and fix the no of decimals . How do
we
do it in excel 2007?

please give step by step instruction

For the OP

See also this example for a menu in the QAT for macro's you want to
use in all your workbooks
http://www.rondebruin.nl/qat.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jon Peltier" wrote in message ...
Microsoft has decided that some of its users are not savvy enough to handle
custom toolbars, therefore nobody gets them anymore. However, there is this
shadow of a toolbar called the QAT (Quick Access Toolbar) which you can add
controls to. Right click on a control and choose Add To Quick Access
Toolbar.

If you're not scared to learn some XML coding, you can create a new custom
tab for your ribbon. See Ron de Bruin's site:
http://www.rondebruin.nl/ribbon.htm

For the decimal places, click on the big ugly round Office button in the top
left, click on Excel Options, click on Advanced, under Editing Options,
click in the Automatically Insert a Decimal Point box, and enter the number
of digits you want.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"vinay kumra" <vinay wrote in message
...
In excel 2003 we could go to customise and a new tool bar . How do we do
it
in excel 2007.


in excel 2003 we could go to options and fix the no of decimals . How do
we
do it in excel 2007?

please give step by step instruction

I am trying to write a macro in which I could change the decimal setting to
any no in excel 2003 by doing the following steps

tools options Fixed Decimal . I used to change the no of decimal places
and macro use to change accordingly for the no of places.

I would like to know how to do this is excel 2007.



"Jon Peltier" wrote:

Microsoft has decided that some of its users are not savvy enough to handle
custom toolbars, therefore nobody gets them anymore. However, there is this
shadow of a toolbar called the QAT (Quick Access Toolbar) which you can add
controls to. Right click on a control and choose Add To Quick Access
Toolbar.

If you're not scared to learn some XML coding, you can create a new custom
tab for your ribbon. See Ron de Bruin's site:
http://www.rondebruin.nl/ribbon.htm

For the decimal places, click on the big ugly round Office button in the top
left, click on Excel Options, click on Advanced, under Editing Options,
click in the Automatically Insert a Decimal Point box, and enter the number
of digits you want.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"vinay kumra" <vinay wrote in message
...
In excel 2003 we could go to customise and a new tool bar . How do we do
it
in excel 2007.


in excel 2003 we could go to options and fix the no of decimals . How do
we
do it in excel 2007?

please give step by step instruction

I am trying to write a macro in which I could change the decimal setting to
any no in excel 2003 by doing the following steps

tools options Fixed Decimal . I used to change the no of decimal places
and macro use to change accordingly for the no of places.

I would like to know how to do this is excel 2007.

"Ron de Bruin" wrote:

For the OP

See also this example for a menu in the QAT for macro's you want to
use in all your workbooks
http://www.rondebruin.nl/qat.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jon Peltier" wrote in message ...
Microsoft has decided that some of its users are not savvy enough to handle
custom toolbars, therefore nobody gets them anymore. However, there is this
shadow of a toolbar called the QAT (Quick Access Toolbar) which you can add
controls to. Right click on a control and choose Add To Quick Access
Toolbar.

If you're not scared to learn some XML coding, you can create a new custom
tab for your ribbon. See Ron de Bruin's site:
http://www.rondebruin.nl/ribbon.htm

For the decimal places, click on the big ugly round Office button in the top
left, click on Excel Options, click on Advanced, under Editing Options,
click in the Automatically Insert a Decimal Point box, and enter the number
of digits you want.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"vinay kumra" <vinay wrote in message
...
In excel 2003 we could go to customise and a new tool bar . How do we do
it
in excel 2007.


in excel 2003 we could go to options and fix the no of decimals . How do
we
do it in excel 2007?

please give step by step instruction

I am trying to write a macro in which I could change the decimal setting to
any no in excel 2003 by doing the following steps

tools options Fixed Decimal . I used to change the no of decimal places
and macro use to change accordingly for the no of places.

I would like to know how to do this is excel 2007.

"jo" wrote:

Hi
I am on XP but I should imagine the following will work:
highlight all the cells you wish to change the decimal place settings for.
click on the 'format' drop down menu
chose the 'cells' option from the drop down list
click on the 'number' tab at the top of the window that appears
in the 'category' box in the left of the window chose 'number.
in the left of the window you will see that you can change the decimal
places you need.
Hope this helps.

"vinay kumra" wrote:

In excel 2003 we could go to customise and a new tool bar . How do we do it
in excel 2007.


in excel 2003 we could go to options and fix the no of decimals . How do we
do it in excel 2007?

please give step by step instruction

I am trying to write a macro in which I could change the decimal setting to
any no in excel 2003 by doing the following steps

tools options Fixed Decimal . I used to change the no of decimal places
and macro use to change accordingly for the no of places.

I would like to know how to do this is excel 2007.

"Ron de Bruin" wrote:

For the OP

See also this example for a menu in the QAT for macro's you want to
use in all your workbooks
http://www.rondebruin.nl/qat.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jon Peltier" wrote in message ...
Microsoft has decided that some of its users are not savvy enough to handle
custom toolbars, therefore nobody gets them anymore. However, there is this
shadow of a toolbar called the QAT (Quick Access Toolbar) which you can add
controls to. Right click on a control and choose Add To Quick Access
Toolbar.

If you're not scared to learn some XML coding, you can create a new custom
tab for your ribbon. See Ron de Bruin's site:
http://www.rondebruin.nl/ribbon.htm

For the decimal places, click on the big ugly round Office button in the top
left, click on Excel Options, click on Advanced, under Editing Options,
click in the Automatically Insert a Decimal Point box, and enter the number
of digits you want.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"vinay kumra" <vinay wrote in message
...
In excel 2003 we could go to customise and a new tool bar . How do we do
it
in excel 2007.


in excel 2003 we could go to options and fix the no of decimals . How do
we
do it in excel 2007?

please give step by step instruction

Instead of reposting the question multiple times as a follow up to each
response you receive, read one or two of the responses.

You want this:
tools options Fixed Decimal

I gave you this:
For the decimal places, click on the big ugly round Office button in the
top
left, click on Excel Options, click on Advanced, under Editing Options,
click in the Automatically Insert a Decimal Point box, and enter the
number
of digits you want.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"vinay kumra" wrote in message
...
I am trying to write a macro in which I could change the decimal setting to
any no in excel 2003 by doing the following steps

tools options Fixed Decimal . I used to change the no of decimal
places
and macro use to change accordingly for the no of places.

I would like to know how to do this is excel 2007.



"Jon Peltier" wrote:

Microsoft has decided that some of its users are not savvy enough to
handle
custom toolbars, therefore nobody gets them anymore. However, there is
this
shadow of a toolbar called the QAT (Quick Access Toolbar) which you can
add
controls to. Right click on a control and choose Add To Quick Access
Toolbar.

If you're not scared to learn some XML coding, you can create a new
custom
tab for your ribbon. See Ron de Bruin's site:
http://www.rondebruin.nl/ribbon.htm

For the decimal places, click on the big ugly round Office button in the
top
left, click on Excel Options, click on Advanced, under Editing Options,
click in the Automatically Insert a Decimal Point box, and enter the
number
of digits you want.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"vinay kumra" <vinay wrote in message
...
In excel 2003 we could go to customise and a new tool bar . How do we
do
it
in excel 2007.


in excel 2003 we could go to options and fix the no of decimals . How
do
we
do it in excel 2007?

please give step by step instruction

You generally do not change the number of DP by setting "Fixed Decimal" unless
you want to enter 1234 and have it return 12.34 or 1.234 etc.

DP settings are found at FormatCellsNumberNumber.........DP

But you may know what you are asking for.

See Ron de Bruin's site for where to find 2007 commands.

http://www.rondebruin.nl/0307commands.htm


Gord Dibben MS Excel MVP

On Sat, 19 Apr 2008 22:57:00 -0700, vinay kumra
wrote:

I am trying to write a macro in which I could change the decimal setting to
any no in excel 2003 by doing the following steps

tools options Fixed Decimal . I used to change the no of decimal places
and macro use to change accordingly for the no of places.

I would like to know how to do this is excel 2007.



"Jon Peltier" wrote:

Microsoft has decided that some of its users are not savvy enough to handle
custom toolbars, therefore nobody gets them anymore. However, there is this
shadow of a toolbar called the QAT (Quick Access Toolbar) which you can add
controls to. Right click on a control and choose Add To Quick Access
Toolbar.

If you're not scared to learn some XML coding, you can create a new custom
tab for your ribbon. See Ron de Bruin's site:
http://www.rondebruin.nl/ribbon.htm

For the decimal places, click on the big ugly round Office button in the top
left, click on Excel Options, click on Advanced, under Editing Options,
click in the Automatically Insert a Decimal Point box, and enter the number
of digits you want.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"vinay kumra" <vinay wrote in message
...
In excel 2003 we could go to customise and a new tool bar . How do we do
it
in excel 2007.


in excel 2003 we could go to options and fix the no of decimals . How do
we
do it in excel 2007?

please give step by step instruction

Addition........turn on the macro recorder whilst changing the setting.


Gord

On Sun, 20 Apr 2008 09:13:24 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

You generally do not change the number of DP by setting "Fixed Decimal" unless
you want to enter 1234 and have it return 12.34 or 1.234 etc.

DP settings are found at FormatCellsNumberNumber.........DP

But you may know what you are asking for.

See Ron de Bruin's site for where to find 2007 commands.

http://www.rondebruin.nl/0307commands.htm


Gord Dibben MS Excel MVP

On Sat, 19 Apr 2008 22:57:00 -0700, vinay kumra
wrote:

I am trying to write a macro in which I could change the decimal setting to
any no in excel 2003 by doing the following steps

tools options Fixed Decimal . I used to change the no of decimal places
and macro use to change accordingly for the no of places.

I would like to know how to do this is excel 2007.



"Jon Peltier" wrote:

Microsoft has decided that some of its users are not savvy enough to handle
custom toolbars, therefore nobody gets them anymore. However, there is this
shadow of a toolbar called the QAT (Quick Access Toolbar) which you can add
controls to. Right click on a control and choose Add To Quick Access
Toolbar.

If you're not scared to learn some XML coding, you can create a new custom
tab for your ribbon. See Ron de Bruin's site:
http://www.rondebruin.nl/ribbon.htm

For the decimal places, click on the big ugly round Office button in the top
left, click on Excel Options, click on Advanced, under Editing Options,
click in the Automatically Insert a Decimal Point box, and enter the number
of digits you want.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"vinay kumra" <vinay wrote in message
...
In excel 2003 we could go to customise and a new tool bar . How do we do
it
in excel 2007.


in excel 2003 we could go to options and fix the no of decimals . How do
we
do it in excel 2007?

please give step by step instruction