PDA

View Full Version : Incomplete print

Manning
April 28th 04, 05:26 PM
When printing lables with dollar amounts the printed
does not print the 00s after the decimal. $10.30 prints
as 10.3 and $10.00 prints as just 10.

Can some one please help?

Thanks
Cari \(MS MVP\)
April 28th 04, 05:26 PM
With which software application are you printing?
--
Cari (MS-MVP Windows Client - Printing, Imaging & Hardware)
www.coribright.com

"Manning" > wrote in message
...
> When printing lables with dollar amounts the printed
> does not print the 00s after the decimal. $10.30 prints
> as 10.3 and $10.00 prints as just 10.
>
> Can some one please help?
>
> Thanks
Cerridwen
April 28th 04, 05:29 PM
Cari (MS MVP) wrote:
> With which software application are you printing?

My guess would be Excel, and he has it set to limit to one decimal place. If
there is nothing after the decimal point, Excel will ignore it.
Cari \(MS MVP\)
April 28th 04, 05:30 PM
With which software application are you printing?
--
Cari (MS-MVP Windows Client - Printing, Imaging & Hardware)
www.coribright.com

"Manning" > wrote in message
...
> When printing lables with dollar amounts the printed
> does not print the 00s after the decimal. $10.30 prints
> as 10.3 and $10.00 prints as just 10.
>
> Can some one please help?
>
> Thanks
Cerridwen
April 28th 04, 05:35 PM
Cari (MS MVP) wrote:
> With which software application are you printing?

My guess would be Excel, and he has it set to limit to one decimal place. If
there is nothing after the decimal point, Excel will ignore it.
NotKathy
May 1st 04, 01:10 AM
We had the same problem using Excel SS as a Mail Merge's
Data Source. The formatting was not coming across.
The fix was the go to Word and then in Tools,
Options...General Tab...
Check Confirm Conversion on Open. You only have to do
this once.
Then when you select the Excel SS as the data source in a
Word mail merge, at the prompt for the connection type,
choose the DDE type.
This is one part of the new style of Mail Merge that
confuses the heck out of our experienced Mail Merge
users. But it is the price of upgrading. :-)

>-----Original Message-----
>Cari (MS MVP) wrote:
>> With which software application are you printing?
>
>My guess would be Excel, and he has it set to limit to
one decimal place. If
>there is nothing after the decimal point, Excel will
ignore it.
>
>
>
>.
>
NotKathy
May 1st 04, 01:35 AM
We had the same problem using Excel SS as a Mail Merge's
Data Source. The formatting was not coming across.
The fix was the go to Word and then in Tools,
Options...General Tab...
Check Confirm Conversion on Open. You only have to do
this once.
Then when you select the Excel SS as the data source in a
Word mail merge, at the prompt for the connection type,
choose the DDE type.
This is one part of the new style of Mail Merge that
confuses the heck out of our experienced Mail Merge
users. But it is the price of upgrading. :-)

>-----Original Message-----
>Cari (MS MVP) wrote:
>> With which software application are you printing?
>
>My guess would be Excel, and he has it set to limit to
one decimal place. If
>there is nothing after the decimal point, Excel will
ignore it.
>
>
>
>.
>
NotKathy
May 1st 04, 01:37 AM
We had the same problem using Excel SS as a Mail Merge's
Data Source. The formatting was not coming across.
The fix was the go to Word and then in Tools,
Options...General Tab...
Check Confirm Conversion on Open. You only have to do
this once.
Then when you select the Excel SS as the data source in a
Word mail merge, at the prompt for the connection type,
choose the DDE type.
This is one part of the new style of Mail Merge that
confuses the heck out of our experienced Mail Merge
users. But it is the price of upgrading. :-)

>-----Original Message-----
>Cari (MS MVP) wrote:
>> With which software application are you printing?
>
>My guess would be Excel, and he has it set to limit to
one decimal place. If
>there is nothing after the decimal point, Excel will
ignore it.
>
>
>
>.
>
NotKathy
May 1st 04, 05:36 AM
We had the same problem using Excel SS as a Mail Merge's
Data Source. The formatting was not coming across.
The fix was the go to Word and then in Tools,
Options...General Tab...
Check Confirm Conversion on Open. You only have to do
this once.
Then when you select the Excel SS as the data source in a
Word mail merge, at the prompt for the connection type,
choose the DDE type.
This is one part of the new style of Mail Merge that
confuses the heck out of our experienced Mail Merge
users. But it is the price of upgrading. :-)

>-----Original Message-----
>Cari (MS MVP) wrote:
>> With which software application are you printing?
>
>My guess would be Excel, and he has it set to limit to
one decimal place. If
>there is nothing after the decimal point, Excel will
ignore it.
>
>
>
>.
>
NotKathy
May 1st 04, 05:36 AM
We had the same problem using Excel SS as a Mail Merge's
Data Source. The formatting was not coming across.
The fix was the go to Word and then in Tools,
Options...General Tab...
Check Confirm Conversion on Open. You only have to do
this once.
Then when you select the Excel SS as the data source in a
Word mail merge, at the prompt for the connection type,
choose the DDE type.
This is one part of the new style of Mail Merge that
confuses the heck out of our experienced Mail Merge
users. But it is the price of upgrading. :-)

>-----Original Message-----
>Cari (MS MVP) wrote:
>> With which software application are you printing?
>
>My guess would be Excel, and he has it set to limit to
one decimal place. If
>there is nothing after the decimal point, Excel will
ignore it.
>
>
>
>.
>
NotKathy
May 1st 04, 07:10 AM
We had the same problem using Excel SS as a Mail Merge's
Data Source. The formatting was not coming across.
The fix was the go to Word and then in Tools,
Options...General Tab...
Check Confirm Conversion on Open. You only have to do
this once.
Then when you select the Excel SS as the data source in a
Word mail merge, at the prompt for the connection type,
choose the DDE type.
This is one part of the new style of Mail Merge that
confuses the heck out of our experienced Mail Merge
users. But it is the price of upgrading. :-)

>-----Original Message-----
>Cari (MS MVP) wrote:
>> With which software application are you printing?
>
>My guess would be Excel, and he has it set to limit to
one decimal place. If
>there is nothing after the decimal point, Excel will
ignore it.
>
>
>
>.
>
NotKathy
May 1st 04, 07:18 AM
We had the same problem using Excel SS as a Mail Merge's
Data Source. The formatting was not coming across.
The fix was the go to Word and then in Tools,
Options...General Tab...
Check Confirm Conversion on Open. You only have to do
this once.
Then when you select the Excel SS as the data source in a
Word mail merge, at the prompt for the connection type,
choose the DDE type.
This is one part of the new style of Mail Merge that
confuses the heck out of our experienced Mail Merge
users. But it is the price of upgrading. :-)

>-----Original Message-----
>Cari (MS MVP) wrote:
>> With which software application are you printing?
>
>My guess would be Excel, and he has it set to limit to
one decimal place. If
>there is nothing after the decimal point, Excel will
ignore it.
>
>
>
>.
>
NotKathy
May 1st 04, 08:43 AM
We had the same problem using Excel SS as a Mail Merge's
Data Source. The formatting was not coming across.
The fix was the go to Word and then in Tools,
Options...General Tab...
Check Confirm Conversion on Open. You only have to do
this once.
Then when you select the Excel SS as the data source in a
Word mail merge, at the prompt for the connection type,
choose the DDE type.
This is one part of the new style of Mail Merge that
confuses the heck out of our experienced Mail Merge
users. But it is the price of upgrading. :-)

>-----Original Message-----
>Cari (MS MVP) wrote:
>> With which software application are you printing?
>
>My guess would be Excel, and he has it set to limit to
one decimal place. If
>there is nothing after the decimal point, Excel will
ignore it.
>
>
>
>.
>
Google