Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Getting Currency to display right in mail merges


  • Please log in to reply

#1
Accipiter

Accipiter

    New Member

  • Member
  • Pip
  • 1 posts
ok, so i have an access database that has a few fields which are currency...when I merge them into ms word, if there's a 0 on the end of the number in access (for instance $1.10), word displays it in the merge as 1.1...how the heck do i fix this?
  • 0

Advertisements


#2
Octagonal

Octagonal

    Member 2k

  • Member
  • PipPipPipPipPip
  • 2,528 posts
Hi Accipiter

I had a similar problem a while ago with a Date field. First of all, make sure that you have at least SP3 update if you are using Office XP. Then have a look at this link for more info on the problem. If you use the workaround make sure that you have {MERGEFIELD number \# $####,0.00} note the 0.00 after the comma. This should fix your problem.

HTH
"O"
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP