Format of data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris - 04 Jun 2004 15:49 GMT

I have an Excel 2002 spreadsheet with several formulae on
them. The spreadsheet is formatted to 2 decimal places.

I need to mail merge this data to word, but when I try, I
get up to 8 decimal places.

I can't find a way to format the data in Word from the
merge.

Reply to this Message

Graham Mayor - 04 Jun 2004 16:20 GMT

Use a switch to restrict the display to two decimal places eg
{Mergefield Number \# ",0.00"}
see http://www.gmayor.com/formatting_word_fields.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>><

> I have an Excel 2002 spreadsheet with several formulae on
> them. The spreadsheet is formatted to 2 decimal places.
[quoted text clipped - 4 lines]
> I can't find a way to format the data in Word from the
> merge.

Reply to this Message

- 08 Jun 2004 15:30 GMT

Thanks, that worked!

My next query is about merging a date field. In my source
document, I have the date in UK format (i.e. dd/mm/yyyy).
When I try and merge it, it displays it in teh mm/dd/yyyy
format. Is there anything I can do about this (before I
go grey!) I've tried fooling it, by changing my source
document to US, but that didn't help.

>-----Original Message-----
>Use a switch to restrict the display to two decimal places eg
[quoted text clipped - 11 lines]
>
>.

Reply to this Message

Graham Mayor - 08 Jun 2004 17:23 GMT

See
http://groups.google.co.uk/groups?hl=en&lr=&ie=UTF-8&threadm=ufcHgf%23yCHA.2592%
40TK2MSFTNGP10&rnum=7&prev=/groups%3Fsourceid%3Dnavclient%26q%3DUS%2BUK%2Bdate%2
Bformat%2BPeter%2BJamieson

for an explanation.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>><

> Thanks, that worked!
>
[quoted text clipped - 29 lines]
>>
>> .

Reply to this Message