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