Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
simona2000
 | Femeie
25 ani
Galati
cauta Barbat
25 - 53 ani |
|
TonyTzu
Moderator
 Inregistrat: acum 12 ani
Postari: 252
|
|
Source:
Use a custom number format that doesn't show zeros, for example, one of these:
If your decimal separator is . (point):
$0.00;($.00);;@
0.00%;-0.00%;;@
0;0;;@
If your decimal separator is , (comma):
$0,00;($,00);;@
0,00%;-0,00%;;@
0;0;;@
Source:
If you want to display thousands separator you can use the following format:
#.###;-#.###,;;@
|
|
| pus acum 6 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 739
|
|
Source:
I used the following on the table with values used to make the chart:
1. Select the data range.
2. Click the Number group's dialog launcher (Home tab). In Excel 2003, right-click the selected range and choose Format Cells.
3. In the resulting dialog box, choose Custom from the Category list.
4. In the Type field, enter 0;;;
Since I had values with no decimals I used the above: 0;;;
For numbers with decimals use: 0,0;;;
For percentages use: 0,0%;;;
For numbers with 2 decimals and thousands separator, i used: #.0,00;;;
Modificat de TRaP (acum 5 ani)
|
|
| pus acum 5 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 739
|
|
Don't display decimals in table (raw data for charts):
|
|
| pus acum 1 an |
|