in excel 2003 we could add a new toolbar .how to do it excel 2007

V

vinay kumra

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
 
J

jo

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.
 
J

Jon Peltier

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
 
V

vinay kumra

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.
 
V

vinay kumra

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.
 
V

vinay kumra

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.
 
V

vinay kumra

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.
 
J

Jon Peltier

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
 
G

Gord Dibben

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 Format>Cells>Number>Number.........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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top