Reply
 
Thread Tools Display Modes
  #1   Report Post  
Ricky Gibson
 
Posts: n/a
Default Formatting a number

I merged some data from an excel-sheet into a table in my Word-document.
In excel I have a cel with 3,4% in it. After the merge I get in Word (in
the cel in my Word-table) the following: 3,4000000000E-2
With Alt+F9 I show the field: {MERGEFIELD "Percentage"}
I tried to format the field as follows: {MERGEFIELD "Percentage" \#,# }
That does not work. This is what I got from the help in Word.
It looks like I am doing something wrong, but what?

Can someone help me?

Thanks,
Ricky


  #2   Report Post  
Suzanne S. Barnhill
 
Posts: n/a
Default

See http://www.gmayor.com/formatting_word_fields.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Ricky Gibson" wrote in message
.. .
I merged some data from an excel-sheet into a table in my Word-document.
In excel I have a cel with 3,4% in it. After the merge I get in Word (in
the cel in my Word-table) the following: 3,4000000000E-2
With Alt+F9 I show the field: {MERGEFIELD "Percentage"}
I tried to format the field as follows: {MERGEFIELD "Percentage" \#,# }
That does not work. This is what I got from the help in Word.
It looks like I am doing something wrong, but what?

Can someone help me?

Thanks,
Ricky



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
Different alignment formatting for header & page number on same line Dave New Users 4 August 4th 05 06:18 PM
loss of phone number formatting when merged macropod Mailmerge 2 April 1st 05 08:35 AM
table of contents and page number formatting no1impt Microsoft Word Help 3 February 22nd 05 06:53 PM
How do I maintain number formatting in a mail merge? Skittles Mailmerge 1 January 28th 05 03:22 AM
Formatting Issue on Number Field Brig Mailmerge 2 January 26th 05 02:18 PM


All times are GMT +1. The time now is 03:58 AM.

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"