Thread: need to display 123,000 instead of 123000 using mail merge
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
  
Posts: 2,722
Default need to display 123,000 instead of 123000 using mail merge
You need to physically convert it before importing. Use the formula:

=TEXT(A2,"#,###")

Now when you import it into a word document the comma will remain.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"ronw55" wrote:

What do I have to do when using mail merge to get a large number to display
in a word document letter with a comma?
Reply With QuoteReply With Quote