\# "$,0.00 ($,0.00) '-'" for currency, with brackets around negative numbers and a hyphen for 0 values \# $,0 for rounded whole dollars with a thousands separator \# ,0.00 for numbers accurate to two decimal places, with a thousands separator \# ,0 for rounded whole numbers with a thousands separator Other numeric picture switch possibilities include: Position the cursor anywhere in this field and press F9 to update it.It should look something like (or whatever other numeric format you prefer - see below) Press Shift-F9 to reveal the field coding.We have that issue every now and then with Word documents in our office - so here's the resolution Ever had the issue where data is formatted and displaying correctly in Excel and when you do a mail merge in Word, the formatting doesn't replicate what the Excel data looks like?įor example the Excel data is displaying as $1,000.00 (currency formatted).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |