#### In Excel spreadsheet after Export from Crystal

[Guest]

We are running a report in Crystal and exporting the results into Excel. "0"
data in columns is displaying in Excel as "#####".

Can anyone explain why "0"s are not displaying in this exported report out
of Crystal to Excel???

Any help would be greatly appreciated.

Thanks!

wnfisba

 

[Guest]

How is your data formatted? Numbers? Text? Currency? Time? Depending on
its format, 0s can be shown as #####

Dave

 

[Guest]

I think the columns are automatically being formatted as I export from
Crystal to Excel. I looked at the cell format and it Custom and I have pasted
the formula below...

#,##0.00_);-#,##0.00;"<Default Format>"

The rows with data are appearing fine. And like I said, it seems to be
dynamically assigning this format formula to what it determines to be numbers
in columns.

Any additional help would be GREATLY appreciated.

Thanks!

 

[Guest]

A couple of things to check:

1) What happens when you make the columns where #### appears wider? Do the
0s show up correctly?

2) What happens when you format the cells where #### appears as text? Do
the 0s show up correctly?

Other than that I would check the settings you use when you export data from
Crystal reports. You may need to use a different number format.

 

[Guest]

We are actually finding that "0"s are appearing as "#####" when exporting out
of Crystal to Excel 2003. Yet it seems to display "0" in Microsoft Excel 2002.

Any ideas???

 

[Guest]

Save in XL 2002 and open in 2003 as needed.