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
--
Brevity is the soul of wit.


"wnfisba" wrote:

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

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!


"Dave F" wrote:

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

Dave
--
Brevity is the soul of wit.


"wnfisba" wrote:

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

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.
--
Brevity is the soul of wit.


"wnfisba" wrote:

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!


"Dave F" wrote:

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

Dave
--
Brevity is the soul of wit.


"wnfisba" wrote:

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

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???

"wnfisba" wrote:

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

Save in XL 2002 and open in 2003 as needed.
--
Brevity is the soul of wit.


"wnfisba" wrote:

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???

"wnfisba" wrote:

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