To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108437 Issue #|108437 Summary|Need to format cells with M, K, B Component|Spreadsheet Version|OOO310m9 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|timjowers
------- Additional comments from timjow...@openoffice.org Mon Jan 18 19:49:57 +0000 2010 ------- Need a formatted code to tell Calc to use 3 or less digits and then a formatting number. Similar to E for Exponential but use M, B, or K. Trying to figure out 7E07 is 70M and 32E13 is 1.3T is tough on the reader. Should be able to select "Number" as formatting and then tell it to use K,M,B,T formatting. Would be nice to be able to specify the number of digits as one can with other formats. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org