Hi sorry for the questions btu I have had them for a while and just discovred
these boards. On a company template i have drop down boxes with dollar values
in them. When looking at the sheet itself everything looks lined up correctly
but once i go to print preview or print there is now about an inch space
between the last word and the dollar value, there are no cells in between, no
extra spaces, i have been working on this for weeks and i have not been able
to figure it out. This is happening on multiple locations on my worksheet so
i ruled out a simple typo or something like that. Pleas help/

Hi,

This is probably a print driver issue. Test the file on a machine that uses
a different type of printer.

A second and less likely option would be to make sure the cell format is
Currency not Accounting. Select some of the offending cells and choose
Format, Cells, Number tab, and choose Currency.

A third option would be to 1. remove the currency formatting or 2. to
replace it with the Custom format "$"#,##0.00 or some decimal variation of
this.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"C Vi" wrote:

Hi sorry for the questions btu I have had them for a while and just discovred
these boards. On a company template i have drop down boxes with dollar values
in them. When looking at the sheet itself everything looks lined up correctly
but once i go to print preview or print there is now about an inch space
between the last word and the dollar value, there are no cells in between, no
extra spaces, i have been working on this for weeks and i have not been able
to figure it out. This is happening on multiple locations on my worksheet so
i ruled out a simple typo or something like that. Pleas help/

I tryed different printers and computers and it makes no difference. The gap
comes before the brop down box if that any help. Also, i am using Excell 2007

"Shane Devenshire" wrote:

Hi,

This is probably a print driver issue. Test the file on a machine that uses
a different type of printer.

A second and less likely option would be to make sure the cell format is
Currency not Accounting. Select some of the offending cells and choose
Format, Cells, Number tab, and choose Currency.

A third option would be to 1. remove the currency formatting or 2. to
replace it with the Custom format "$"#,##0.00 or some decimal variation of
this.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"C Vi" wrote:

Hi sorry for the questions btu I have had them for a while and just discovred
these boards. On a company template i have drop down boxes with dollar values
in them. When looking at the sheet itself everything looks lined up correctly
but once i go to print preview or print there is now about an inch space
between the last word and the dollar value, there are no cells in between, no
extra spaces, i have been working on this for weeks and i have not been able
to figure it out. This is happening on multiple locations on my worksheet so
i ruled out a simple typo or something like that. Pleas help/

If desired, send your wb to my address and I'll have a look.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"C Vi" wrote in message
...
Hi sorry for the questions btu I have had them for a while and just
discovred
these boards. On a company template i have drop down boxes with dollar
values
in them. When looking at the sheet itself everything looks lined up
correctly
but once i go to print preview or print there is now about an inch space
between the last word and the dollar value, there are no cells in between,
no
extra spaces, i have been working on this for weeks and i have not been
able
to figure it out. This is happening on multiple locations on my worksheet
so
i ruled out a simple typo or something like that. Pleas help/

I looked and found NO problem...???

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
If desired, send your wb to my address and I'll have a look.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"C Vi" wrote in message
...
Hi sorry for the questions btu I have had them for a while and just
discovred
these boards. On a company template i have drop down boxes with dollar
values
in them. When looking at the sheet itself everything looks lined up
correctly
but once i go to print preview or print there is now about an inch space
between the last word and the dollar value, there are no cells in
between, no
extra spaces, i have been working on this for weeks and i have not been
able
to figure it out. This is happening on multiple locations on my worksheet
so
i ruled out a simple typo or something like that. Pleas help/