Price per day - Word 2000 Chris Stammers 5/14/2007 3:30:00 PM Hello, I have to work out a 'pence per day' figure in a merge. I have come up with this formula - could someone tell me if it looks right please? { = ({ MERGEFIELD myamount }/30) * 100 \#"00p" } Thanks, Chris

Re: Price per day - Word 2000 "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 5/14/2007 3:47:11 PM Assuming you're starting with a "pounds&pence per month" figure it looks OK to me. You only really need "00p" if you always want at least two digits before the "p". If you're happy with 1p, 23p, 456p, you should be able to use "0p". Peter Jamieson "Chris Stammers" <ChrisStammers[ at ]discussions.microsoft.com> wrote in message news:DBC503C9-7B79-4334-9DCF-8068968D63A0[ at ]microsoft.com... [Quoted Text] > Hello, > > I have to work out a 'pence per day' figure in a merge. I have come up > with > this formula - could someone tell me if it looks right please? > > { = ({ MERGEFIELD myamount }/30) * 100 \#"00p" } > > Thanks, > Chris

Re: Price per day - Word 2000 Chris Stammers 5/14/2007 4:24:02 PM Thanks Peter. Is that always the case with 'pence' formatting? It will always only ever need to be 15p or 20p - 2 digit amounts anyway. In one of my last questions, you gave me the formula to take the decimal point away and just leave the 'pence'. Can I apply your detail below to that query as well? Thanks, Chris "Peter Jamieson" wrote: [Quoted Text] > Assuming you're starting with a "pounds&pence per month" figure it looks OK > to me. You only really need "00p" if you always want at least two digits > before the "p". If you're happy with 1p, 23p, 456p, you should be able to > use "0p". > > Peter Jamieson > > "Chris Stammers" <ChrisStammers[ at ]discussions.microsoft.com> wrote in message > news:DBC503C9-7B79-4334-9DCF-8068968D63A0[ at ]microsoft.com... > > Hello, > > > > I have to work out a 'pence per day' figure in a merge. I have come up > > with > > this formula - could someone tell me if it looks right please? > > > > { = ({ MERGEFIELD myamount }/30) * 100 \#"00p" } > > > > Thanks, > > Chris >

Re: Price per day - Word 2000 "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 5/14/2007 4:36:46 PM Yes, if you have \#"0" it just means "always have at least one digit" [Quoted Text] > Can I apply your detail below to that query as well? Yes. These switches are all covered in Word Help, at least in Word 2003. Peter Jamieson "Chris Stammers" <ChrisStammers[ at ]discussions.microsoft.com> wrote in message news:812AA731-F3CD-440B-8E03-14759CF4DF6E[ at ]microsoft.com... > Thanks Peter. Is that always the case with 'pence' formatting? It will > always > only ever need to be 15p or 20p - 2 digit amounts anyway. In one of my > last > questions, you gave me the formula to take the decimal point away and just > leave the 'pence'. Can I apply your detail below to that query as well? > > Thanks, > Chris > > "Peter Jamieson" wrote: > >> Assuming you're starting with a "pounds&pence per month" figure it looks >> OK >> to me. You only really need "00p" if you always want at least two digits >> before the "p". If you're happy with 1p, 23p, 456p, you should be able to >> use "0p". >> >> Peter Jamieson >> >> "Chris Stammers" <ChrisStammers[ at ]discussions.microsoft.com> wrote in >> message >> news:DBC503C9-7B79-4334-9DCF-8068968D63A0[ at ]microsoft.com... >> > Hello, >> > >> > I have to work out a 'pence per day' figure in a merge. I have come up >> > with >> > this formula - could someone tell me if it looks right please? >> > >> > { = ({ MERGEFIELD myamount }/30) * 100 \#"00p" } >> > >> > Thanks, >> > Chris >>