Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #5  
Old 08-23-2006, 01:08 AM
AJ
Guest
 
Posts: n/a
Default Re: Rounding error - HELP!

That did the trick, Cal. Thanks a lot!!!!

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, AJ wrote:
> > Thanks, Cal, for the quick reply. How best is it to change the currency in
> > the OS? I am using Windows XP SP2. In my regional settings I am using
> > English [Canada] with the default currency settings. Thanks again.

> There would probably be effects you did not like, but you could
> always switch it back.
> Start-> Settings-> ControlPanel-> RegionalAndLanguage...-> RegionalOptions-> Customize-> Currency
> Change the No.OfDigitsAfterDecimal to 4. OK. OK. Reboot the
> computer.
> > > "Cal Learner-- MVP" wrote:
> > > > In microsoft.public.money, AJ wrote:
> > > > > > Hi, Cal
> > > > > > > Thanks for the post but I have already tried that. I've cutomized exhisting
> > > > views. Created my own views using 2, 3, 4, 5 decimal places. It continues
> > > > to round up to the 2nd decimal place irregardless of how many decimal places
> > > > I save. As mentioned if I Save 3 decimal places for a Avg Cost that should
> > > > be $0.135, it will show $0.140. If I save 4 decimal places, it would show
> > > > $0.1400. What's going on?????
> > > > > OK. I suspect Money is using the currency settings of the OS.
> > > > > > > > > > > > > > "Cal Learner-- MVP" wrote:
> > > > > > > > In microsoft.public.money, AJ wrote:
> > > > > > > > > > I am using Money 2006 Canadian Standard Edition.
> > > > > > In my Portfolio View I have
> > > > > > an Avg Cost column. I would like to see the Avg Cost using 3 decimal places
> > > > > > but I have found that it always rounds up to 2 decimal places. Even if I put
> > > > > > in 4 or 5 decimal places, it always rounds up to 2 decimal places. Eg:
> > > > > > $0.135 rounds to $0.140 using 3 decimal places. It's driving me nuts! Any
> > > > > > suggestions would be greatly appreciated!!!!!
> > > > > > > > > Go to ChangePortfolioView-> CustomizeCurrentView-> PortfolioColumns
> > > > > and select the column in the right-hand box. Then below that box,
> > > > > change the DecimalPlaces number. Save.
> > > > > >
  #4  
Old 08-22-2006, 10:25 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Rounding error - HELP!

In microsoft.public.money, AJ wrote:

- quote -

> Thanks, Cal, for the quick reply. How best is it to change the currency in
> the OS? I am using Windows XP SP2. In my regional settings I am using
> English [Canada] with the default currency settings. Thanks again.


There would probably be effects you did not like, but you could
always switch it back.

Start-> Settings-> ControlPanel-> RegionalAndLanguage...-> RegionalOptions-> Customize-> Currency
Change the No.OfDigitsAfterDecimal to 4. OK. OK. Reboot the
computer.


- quote -

> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, AJ wrote:
> > > > Hi, Cal
> > > > > Thanks for the post but I have already tried that. I've cutomized exhisting
> > > views. Created my own views using 2, 3, 4, 5 decimal places. It continues
> > > to round up to the 2nd decimal place irregardless of how many decimal places
> > > I save. As mentioned if I Save 3 decimal places for a Avg Cost that should
> > > be $0.135, it will show $0.140. If I save 4 decimal places, it would show
> > > $0.1400. What's going on?????
> > > OK. I suspect Money is using the currency settings of the OS.
> > > > > > > > > "Cal Learner-- MVP" wrote:
> > > > > > In microsoft.public.money, AJ wrote:
> > > > > > > > I am using Money 2006 Canadian Standard Edition.
> > > > > In my Portfolio View I have
> > > > > an Avg Cost column. I would like to see the Avg Cost using 3 decimal places
> > > > > but I have found that it always rounds up to 2 decimal places. Even if I put
> > > > > in 4 or 5 decimal places, it always rounds up to 2 decimal places. Eg:
> > > > > $0.135 rounds to $0.140 using 3 decimal places. It's driving me nuts! Any
> > > > > suggestions would be greatly appreciated!!!!!
> > > > > > > Go to ChangePortfolioView-> CustomizeCurrentView-> PortfolioColumns
> > > > and select the column in the right-hand box. Then below that box,
> > > > change the DecimalPlaces number. Save.
> > > >
  #3  
Old 08-22-2006, 09:05 PM
AJ
Guest
 
Posts: n/a
Default Re: Rounding error - HELP!

Thanks, Cal, for the quick reply. How best is it to change the currency in
the OS? I am using Windows XP SP2. In my regional settings I am using
English [Canada] with the default currency settings. Thanks again.

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, AJ wrote:
> > Hi, Cal
> > > Thanks for the post but I have already tried that. I've cutomized exhisting

> > views. Created my own views using 2, 3, 4, 5 decimal places. It continues
> > to round up to the 2nd decimal place irregardless of how many decimal places
> > I save. As mentioned if I Save 3 decimal places for a Avg Cost that should
> > be $0.135, it will show $0.140. If I save 4 decimal places, it would show
> > $0.1400. What's going on?????

> OK. I suspect Money is using the currency settings of the OS.
> > > > "Cal Learner-- MVP" wrote:
> > > > In microsoft.public.money, AJ wrote:
> > > > > > I am using Money 2006 Canadian Standard Edition.
> > > > In my Portfolio View I have
> > > > an Avg Cost column. I would like to see the Avg Cost using 3 decimal places
> > > > but I have found that it always rounds up to 2 decimal places. Even if I put
> > > > in 4 or 5 decimal places, it always rounds up to 2 decimal places. Eg:
> > > > $0.135 rounds to $0.140 using 3 decimal places. It's driving me nuts! Any
> > > > suggestions would be greatly appreciated!!!!!
> > > > > Go to ChangePortfolioView-> CustomizeCurrentView-> PortfolioColumns
> > > and select the column in the right-hand box. Then below that box,
> > > change the DecimalPlaces number. Save.

> >
  #2  
Old 08-22-2006, 07:56 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Rounding error - HELP!

In microsoft.public.money, AJ wrote:

- quote -

> Hi, Cal
> Thanks for the post but I have already tried that. I've cutomized exhisting
> views. Created my own views using 2, 3, 4, 5 decimal places. It continues
> to round up to the 2nd decimal place irregardless of how many decimal places
> I save. As mentioned if I Save 3 decimal places for a Avg Cost that should
> be $0.135, it will show $0.140. If I save 4 decimal places, it would show
> $0.1400. What's going on?????


OK. I suspect Money is using the currency settings of the OS.


- quote -

> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, AJ wrote:
> > > > I am using Money 2006 Canadian Standard Edition.
> > > In my Portfolio View I have
> > > an Avg Cost column. I would like to see the Avg Cost using 3 decimal places
> > > but I have found that it always rounds up to 2 decimal places. Even if I put
> > > in 4 or 5 decimal places, it always rounds up to 2 decimal places. Eg:
> > > $0.135 rounds to $0.140 using 3 decimal places. It's driving me nuts! Any
> > > suggestions would be greatly appreciated!!!!!
> > > Go to ChangePortfolioView-> CustomizeCurrentView-> PortfolioColumns

> > and select the column in the right-hand box. Then below that box,
> > change the DecimalPlaces number. Save.

>
  #1  
Old 08-22-2006, 07:29 PM
AJ
Guest
 
Posts: n/a
Default Re: Rounding error - HELP!

Hi, Cal

Thanks for the post but I have already tried that. I've cutomized exhisting
views. Created my own views using 2, 3, 4, 5 decimal places. It continues
to round up to the 2nd decimal place irregardless of how many decimal places
I save. As mentioned if I Save 3 decimal places for a Avg Cost that should
be $0.135, it will show $0.140. If I save 4 decimal places, it would show
$0.1400. What's going on?????


"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, AJ wrote:
> > I am using Money 2006 Canadian Standard Edition.
> > In my Portfolio View I have
> > an Avg Cost column. I would like to see the Avg Cost using 3 decimal places
> > but I have found that it always rounds up to 2 decimal places. Even if I put
> > in 4 or 5 decimal places, it always rounds up to 2 decimal places. Eg:
> > $0.135 rounds to $0.140 using 3 decimal places. It's driving me nuts! Any
> > suggestions would be greatly appreciated!!!!!

> Go to ChangePortfolioView-> CustomizeCurrentView-> PortfolioColumns
> and select the column in the right-hand box. Then below that box,
> change the DecimalPlaces number. Save.

 
Old 08-22-2006, 02:41 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Rounding error - HELP!

In microsoft.public.money, AJ wrote:

- quote -

> I am using Money 2006 Canadian Standard Edition.
> In my Portfolio View I have
> an Avg Cost column. I would like to see the Avg Cost using 3 decimal places
> but I have found that it always rounds up to 2 decimal places. Even if I put
> in 4 or 5 decimal places, it always rounds up to 2 decimal places. Eg:
> $0.135 rounds to $0.140 using 3 decimal places. It's driving me nuts! Any
> suggestions would be greatly appreciated!!!!!


Go to ChangePortfolioView-> CustomizeCurrentView-> PortfolioColumns
and select the column in the right-hand box. Then below that box,
change the DecimalPlaces number. Save.
  #-1  
Old 08-22-2006, 02:26 PM
AJ
Guest
 
Posts: n/a
Default Rounding error - HELP!

I am using Money 2006 Canadian Standard Edition. In my Portfolio View I have
an Avg Cost column. I would like to see the Avg Cost using 3 decimal places
but I have found that it always rounds up to 2 decimal places. Even if I put
in 4 or 5 decimal places, it always rounds up to 2 decimal places. Eg:
$0.135 rounds to $0.140 using 3 decimal places. It's driving me nuts! Any
suggestions would be greatly appreciated!!!!!
 

Tags
error, rounding
Similar Threads
Thread Forum Replies Last Post
Money 04 account balance rounding error
M Glass: I am using Money 2004 Deluxe, and when I was checking my account balance (checking account) against what the bank said, I found I was off by $0.01...
Microsoft Money 2 02-14-2004 11:35 PM
Automatic Rounding problems
Fabio Pires: I am using Money 99 and, only on investments section, when I try enter a price or quantity with a decimal part, it simply round it to an integer...
Microsoft Money 2 01-10-2004 06:42 PM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 06:34 PM.