#### In Excel spreadsheet after Export from Crystal

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
How is your data formatted? Numbers? Text? Currency? Time? Depending on
its format, 0s can be shown as #####

Dave
 
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!
 
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.
 
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???
 
Back
Top