Software

Ask something
Question Locked

Excel database export to Word Template

0 helpful
2 replies

by harris

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am trying to export information on an Excel database to a Word document for distribution to our employees. The spreadsheet columns are formatted according to the information included: percentages, dollars, text, etc. However, when I export the information to word, all formatting is lost, i.e. $135,000 appears at 135000; $98.30 appears as 98.3, etc.

How do I get the formatting to export, too?

2 replies

by klutz7

just change your data in excel from numbers to TEXT. Since they are stored as numbers in excel they are converted to text in word document. So if you change it in excel to TEXT in Word it is automatically recognized. 7% will be 7% and not 0.007...$135,000 will be $135,000 and not 135000... :-)

This discussion is closed to new replies.