Price per day - Word 2000

C

Chris Stammers

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
 
P

Peter Jamieson

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
 
C

Chris Stammers

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
 
P

Peter Jamieson

Yes, if you have \#"0" it just means "always have at least one digit"
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
 

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