Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Spreadsheet too much numbers behind the comma
Started 1 month, 3 weeks ago by Walker
Hi, Sometimes when i use a spreadsheet the sum shows a lot of numbers behind the comma. Using version 5.1.1 pro and now 5.2.0 Beta 1. Example 786,16-720,97= 65,1899999999999 instead of 65,19. b4 (=b2-b3) Is there a setting where i can set the amount of numbers behind the comma? Kind regards,
Site: www.website-watcher.com :: Index  www.website-watcher.com :: Index - site profile
Forum: AM-Notebook  AM-Notebook - forum profile
Total authors: 2 authors
Total thread posts: 3 posts
Thread activity: no new posts during last week
Domain info for: aignes.com

Other posts in this thread:

Martin Aignesberger replied 1 month, 3 weeks ago
Right click that cell and select "Format cells" from the context menu. Then you can select the format for numbers. _________________ Martin Aignesberger [SUPPORT]
Size: 303 bytes
Customize:  Customize "<b>Reply 1</b>: Spreadsheet too much numbers behind the comma :: AM-Notebook :: www.website-watcher.com :: Index"

Walker replied 1 month, 3 weeks ago
Thanks very much it works like a charm
Size: 169 bytes
Customize:  Customize "<b>Reply 2</b>: Spreadsheet too much numbers behind the comma :: AM-Notebook :: www.website-watcher.com :: Index"

 

Top contributing authors

Name
Posts
Walker
2
user's latest post:
Spreadsheet too much numbers...
Published (2009-11-01 21:25:00)
Thanks very much it works like a charm
Martin Aignesberger
2
user's latest post:
Spreadsheet too much numbers...
Published (2009-11-01 12:06:00)
Quote: Is there a setting where i can set the amount of numbers behind the comma? Right click that cell and select &quot;Format cells&quot; from the context menu. Then you can select the format for numbers.

Related threads on other sites:

Can VC60 printf () format numbers with comma thouasand...  CodeProject: Discussion Boards. Free source code and programming help - site profile Visual C++ / MFC - forum profile Can VC60 printf () format numbers with comma thouasand seperators, eg 23,123
Can VC60 printf () format numbers with comma thouasand seperators, eg 23,123
Divide id numbers with comma  DevX Forums - site profile Java - forum profile Divide id numbers with comma
Divide id numbers with comma
Numbers with comma  MySQL AB - MySQL Forums - site profile General - forum profile Numbers with comma
Numbers with comma
Problem with sorting of numbers with comma as separator  Zapatec DHTML Forums - site profile AJAX Grid - forum profile Problem with sorting of numbers with comma as separator
Problem with sorting of numbers with comma as separator
Numbers, numbers, numbers. Behind every number is a...  Twitter / MarkEiken - site profile Mark Eiken - forum profile Numbers, numbers, numbers. Behind every number is a name... 6:00 AM Oct 27th from web
Numbers, numbers, numbers. Behind every number is a name... 6:00 AM Oct 27th from web
Printing numbers with comma delimited decimals  MySQL AB - MySQL Forums - site profile Other Migration - forum profile Printing numbers with comma delimited decimals
Printing numbers with comma delimited decimals
Display numbers with comma separator in html - HTML and CSS  www.daniweb.com - IT Tech Talk - site profile HTML and CSS - forum profile Display numbers with comma separator in html - HTML and CSS
Display numbers with comma separator in html - HTML and CSS
How do I save an excel spreadsheet as a comma-delimited...  Excel Help Forum - site profile Excel Miscellaneous - forum profile How do I save an excel spreadsheet as a comma-delimited ASCII file
How do I save an excel spreadsheet as a comma-delimited ASCII file
How to turn Excel Spreadsheet back into Comma Separated  Excel Help Forum - site profile Excel General - forum profile How to turn Excel Spreadsheet back into Comma Separated
How to turn Excel Spreadsheet back into Comma Separated
[RESOLVED] format numbers with comma  VBForums - Visual Basic and VB .NET Discussions and More! - site profile ASP, VB Script - forum profile [RESOLVED] format numbers with comma
[RESOLVED] format numbers with comma
Thread profile page for "Spreadsheet too much numbers behind the comma" on http://www.aignes.com. This report page is a snippet summary view from a single thread "Spreadsheet too much numbers behind the comma", located on the Message Board at http://www.aignes.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity