Dear all,
Some of my reports I run with the Autopilot tend to give problems because Excel changes the number format of the cell that contains the Job No. that looks like it contains a decimal point :? .
Our Job No.'s look like '12345.100' en '12345.200' and in some cases Excel decides to change that (only in Autopilot-mode) into '12345.1' and '12345.2' and I can't find out why :oops: . Job No's like '12345.101' run just fine.
I have tried to work around this by formatting the cell with a fixed number of decimal positions, or as text, but to no avail.
I am sure I am not alone in this, so who can help me solving this annoying issue? :)
Thanks…
Willem
Date
Votes
3 comments
-
Jet Reports Historic Posts Official comment Hi,
are you working with decimal Point in the netherlands? or with a comma? (1,01 or 1.01)
or is is the point for the "thousands" ( 1.001,00 10.001,99)
that's not clear for me…
regards
jetsetter -
Jet Reports Historic Posts Does this same thing happen if you just run the report manually and not through AutoPilot/Scheduler? Do you know what "Type" of field Job No. is within your database? (i.e. Code, Integer, Text, etc)
The reason it works for 12345.101 and not 12345.100 is that Excel is taking out the "unnecessary" zeros. I don't have anything in my DB that would be similar so I can't recreate it.
You could try to have the Jet Function to get the job number in cell D7 (for example). Then in cell E7, use =Text(D7, "#.000") and hide column D in the report. -
Jet Reports Historic Posts Thanks Jet-btr and Jetsetter for your reactions.
It appears that changing the format of cell D5 containing the job no. to 'Text' was enough. Strange, as this did NOT help when this problem started a few weeks ago.
@ JET-btr: I tried your solution, and that did work also ;).
Regards & Thanks,
Willem
Please sign in to leave a comment.