Number Format after Excel Export

[GeneN24]

At times when a number in Crystal has no decimal (105123), when exported to Excel it is made a decimal and cannot be reformatted (105123.00). Does anyone know a way around this?

Thanks

 

[Madawc]

It could be due to the nature of the value. If it had decimals but didn't display them on the report, it might still remember the values when exporting to Excel.

If you logically rounded the values using the command
Round{your.value}
this might get rid of the problem.

Madawc Williams
East Anglia
Great Britain

 

[SurfingGecko]

Try changing the persisted user setting in Excel for numbers/currency to not have any decimal places and see what happens.

I suspect Excel is interpreting the field as a number (as it should) and is applying the applcation settings to the field (cell).



Cheers,

SurfingGecko

http://www.surfinggeckosoftware.com

Home of Crystal Ease