Excel vbcrlf

Hi, in my matrix, i have a cell like: "text1"+ vbcrlf + "text2".
On the matrix, it show correctly, text2 is under text1 because vbcrlf is a
carriage return.
But when i export my matrix to excel, i Have a line between text1 and text2.
it seem that exporting to excel does two vbcrlf and it should do one. I have
rs sp2 and it is not better for this.
Also, how to say to excel to format number to number and not to text.
thanksI ran into this today and ended up using "text1" & Chr(10) & "text2". It
works fine when exporting to Excel.
"Francis" wrote:
> Hi, in my matrix, i have a cell like: "text1"+ vbcrlf + "text2".
> On the matrix, it show correctly, text2 is under text1 because vbcrlf is a
> carriage return.
> But when i export my matrix to excel, i Have a line between text1 and text2.
> it seem that exporting to excel does two vbcrlf and it should do one. I have
> rs sp2 and it is not better for this.
> Also, how to say to excel to format number to number and not to text.
> thanks
>
>|||SStoyko,
Sorry to talk you. Yes. Now you can export to EXCEL file normal.
But :-) when you view the report thru IE, this two lines now is together.
(Under development view, it is O.K. but when user browse it then it is not
look like what it shall be :-)
I had tried Chr(10)/Chr(10) + Chr(13)/vbNewLine/...
I just can not find a solution both work for IE browser and EXCEL :-)
"SStoyko" wrote:
>
> I ran into this today and ended up using "text1" & Chr(10) & "text2". It
> works fine when exporting to Excel.
>
>
> "Francis" wrote:
> > Hi, in my matrix, i have a cell like: "text1"+ vbcrlf + "text2".
> > On the matrix, it show correctly, text2 is under text1 because vbcrlf is a
> > carriage return.
> > But when i export my matrix to excel, i Have a line between text1 and text2.
> > it seem that exporting to excel does two vbcrlf and it should do one. I have
> > rs sp2 and it is not better for this.
> >
> > Also, how to say to excel to format number to number and not to text.
> > thanks
> >
> >
> >