crystal excel export

[Johnny786]

Hello Every one,
while i am exporting the crystal cross tab results to excel, the number field is converting to text field by giving small green triangle at top-left corner of that field in excel sheet...
Is there any way to get rid of that in crysatl before exporting?

 

[hilfy]

Which version of Crystal are you using? Is the field a number in the cross-tab or is it a formula where you've converted a number to text?

Unfortunately, we have very little control over how Crystal exports to anything - just the options they give us on the export screen.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[Johnny786]

Crystal 2008 ; the field in the cross tab is a formula converted to number from text using TONUMBER().

 

[hilfy]

That may be what's causing the problem. Are you using a command or tables in your report? If you're using a command, try converting the text field to a number in the SQL. If you're using tables, try creating a SQL Expression that will convert the text to a number. That way you don't have to use a Crystal formula to convert it and it should export correctly.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.