At 23:46 10/07/2008 +0200, Freddy Van Ingelgom wrote:
Dans une feuille calc j'ai une colonne qui
contient les jours de la semaine sous forme d'un
numéro (1 pour lundi, 2 pour mardi etc).
Je souhaite afficher le jour sous forme de texte (lundi, mardi, etc...).
Existe-t-il une fonction qui réalise ceci?
Sorry, but I do not write French.
You may not need a function, in fact, to complete
this process. You can treat the value as a date
and format it appropriately. Go to Format |
Cells... | Numbers and enter NNN or DDDD in the
"Format code" box at the bottom of the
panel. You will see that this will map 1 to
Sunday, 2 to Monday, and so on - so you will have
to add 1 to your values to create the mapping you need.
Alternatively, if you need to create actual text
values in the cells, you can use the TEXT()
function to create the same effect. Use something like
=TEXT(x+1;"NNN")
- where "x" is your original value.
I am hoping both that the details are similar in
your locale and that you will be able to
translate the terms for your version of OpenOffice!
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
