|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 26th, 2006, 03:43 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
#### In Excel spreadsheet after Export from Crystal
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 
|
|
#2
September 26th, 2006, 03:51 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
#### In Excel spreadsheet after Export from Crystal
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
|
|
#3
September 26th, 2006, 04:11 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
#### In Excel spreadsheet after Export from Crystal
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
|
|
#4
September 26th, 2006, 04:19 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
#### In Excel spreadsheet after Export from Crystal
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
|
|
#5
September 26th, 2006, 04:24 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
#### In Excel spreadsheet after Export from Crystal
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
|
|
#6
September 26th, 2006, 04:41 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
#### In Excel spreadsheet after Export from Crystal
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
