|
#5
| |||
| |||
| 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
| |||
| |||
| In microsoft.public.money, AJ wrote: - quote - > Thanks, Cal, for the quick reply. How best is it to change the currency in
There would probably be effects you did not like, but you could> the OS? I am using Windows XP SP2. In my regional settings I am using > English [Canada] with the default currency settings. Thanks again. 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
| |||
| |||
| 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
| |||
| |||
| In microsoft.public.money, AJ wrote: - quote - > Hi, Cal
OK. I suspect Money is using the currency settings of the OS.> 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????? - 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
| |||
| |||
| 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. |
| | |||
| |||
| In microsoft.public.money, AJ wrote: - quote - > I am using Money 2006 Canadian Standard Edition.
Go to ChangePortfolioView-> CustomizeCurrentView-> PortfolioColumns> 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!!!!! and select the column in the right-hand box. Then below that box, change the DecimalPlaces number. Save. |
|
#-1
| |||
| |||
| 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 | |
| |