Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
reefmespla
Starting Member
3 Posts |
Posted - 2008-09-10 : 10:30:08
|
Hello all,I have a report that I built that is exporting a column that is a textbox text constant that reads:"Small Group A+"The report renders fine to everything except Excel 2007. When I do the excel export the text is rendered as:"Small Group A&"Does anybody have any suggestions on what can be done to make the A+ export as A+ instead of A&?Thanks |
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-09-10 : 20:24:41
|
This is a bit clunky & may not work, but you could try entering <="Small Group A" + chr(43)>in your textbox. |
 |
|
reefmespla
Starting Member
3 Posts |
Posted - 2008-09-11 : 09:01:39
|
Dexter, that worked perfect, thanks for the help! |
 |
|
|
|
|