Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Taz Taz is offline
external usenet poster
 
Posts: 6
Default Number format wrong when using a formula in merge field

I know this is simple but can't seem to find the solution:
The formula is to mulitply a mergefield by 13.33%
The result comes out .000 even using \# $#,###.##
{={mergefield \# $#,###.##}*.13.33}
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Number format wrong when using a formula in merge field

Something more like

{ ={ MERGEFIELD mynumber }*0.1333 \# "$,0.00" }

is more likely to do it. Each pair of {} needs to be the field braces you
can insert using ctrl-F9, not the regular keyboard characters "{" and "}"

Peter Jamieson
"taz" wrote in message
...
I know this is simple but can't seem to find the solution:
The formula is to mulitply a mergefield by 13.33%
The result comes out .000 even using \# $#,###.##
{={mergefield \# $#,###.##}*.13.33}



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I format zip code merge field to add hyphen if zip plus 4? ShaniraW Mailmerge 1 March 7th 06 07:36 PM
Insert Field - Database - Wrong Date Format dns2005 Mailmerge 3 February 23rd 06 04:04 PM
Suppressing Merge Field and text before/after julie Microsoft Word Help 8 November 14th 05 02:50 PM
Wrong mail merge date format sam Mailmerge 1 June 8th 05 01:23 PM
How merge a field with RTF format 1961JCAP Mailmerge 1 December 1st 04 02:30 PM


All times are GMT +1. The time now is 09:25 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"