Thank you Brian! Sorry I was not aware that I was on the English
speaking list!
regards,
Freddy
Brian Barker wrote:
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
