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: deea_printesa la Simpatie.ro
| Femeie 24 ani Dolj cauta Barbat 24 - 48 ani |
|
Mrrrr
AdMiN
Inregistrat: acum 17 ani
Postari: 2186
|
|
If you copied some data from another file, or extracted it to Excel from text for example, you might encounter the problem where even if cell number format is correct (showing as number, time, date etc.), when you try to sort the values in a table, or make a chart, you encounter problems - it won't sort correctly, chart series would disappear etc., you could use the following short VBA code to fix - you must first select your range with problems, then click a button linked to the following code:
Sub TextToFormat() Selection.Value = Selection.Value End Sub |
or
Sub TextToFormat() Selection.Value = Selection.FormulaR1C1 End Sub |
It's like you would F2 and ENTER for each cell, but in just 1 click for all cells in a selection.
Example of problem with series not showing on a chart:
_______________________________________
|
|
pus acum 4 ani |
|