Print Page | Close Window

Excel data not reading incompletely

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22842
Printed Date: 29 Apr 2024 at 5:50am


Topic: Excel data not reading incompletely
Posted By: lillymartirosya
Subject: Excel data not reading incompletely
Date Posted: 26 Nov 2019 at 6:03am
Hello,

Crystal version: 2016

I have an excel file with numbers that look like 1.2356 but it only comes through in Crystal as 1.23. I've tried reformatting the field in Crystal and in Excel but it doesn't work.


Does anyone have any possible solutions.

Thank you.



Replies:
Posted By: kevlray
Date Posted: 26 Nov 2019 at 9:04am
How did you re-format the number?  There is a icon on the tool bar to increase the decimal points.



Print Page | Close Window