- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Its not a bug. The 9.99E is indicating that you will only check the first three places hence the pattern is limiting you to .001 as the smallest number. If you want to display something bigger you will need more 9's. If the number is .0000000299 then the pattern woudl be 9.9999999999E. This will also cuase a number like .00123456 to be displayed as 1.23456E-3. Typically you want only three digits (two decimal places) so th epattern woudl be 9.99zzzzzzzzE.
So your 2.99E-8 will be:
9.99zzzzzzzzE
Are you using an edit pattern or just a display pattern?
Paul
Views
Replies
0 Likes
Total Likes