Help!

Default decimal places for Currency Format


Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Setup RSS
Next:  Graphic Problem after converting to Office 2003  
Author Message
brandie



Joined: Dec 18, 2007
Posts: 3

Location: Columbus, Ohio

PostPosted: Thu May 08, 2008 11:36 am    Post subject: Default decimal places for Currency Format

Is there a way to modify the default number of decimal places in the currency format? I like to use the Currency "button" in the toolbar, but it always sets 2 decimal places, where I like to have 0. Is there a setting to change this, or must I manually change it each time?
Back to top
Fraser79



Joined: Jun 11, 2008
Posts: 2



PostPosted: Wed Jun 11, 2008 9:43 am    Post subject: My question answers yours [Login to view extended thread Info.]

I'm trying to move this option into the ribbon for office 2007. It allows the user to change the decimal place in currency. I don't use Excel at all, but my mother whom is an accountant is always accessing this buried feature.

This window can be accessed by selecting the Office button in the top left corner and then selecting advance options which is beside the exit button.



 <<-- click to expand
Back to top
Fraser79



Joined: Jun 11, 2008
Posts: 2



PostPosted: Wed Jun 11, 2008 10:05 am    Post subject: Solution [Login to view extended thread Info.]

...... for a few days I was contemplating writing my own add-in solution; but as my skills in codeing are moderate at best, I can thankfully say that I managed to find an add-ins here that should solve both of our issues.

Freeware:
Free
http://www.excel-extools.com/screenshots_rx.php
Functionality: excellent

Sharewhare:
approx: $20
http://www.office-addins.com/-excel-addins/significant-digit-assistant.html
functionality: good
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Setup All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum