Cell Format

[Dudule]

Hello, I would like to display in a cell "26 J" (in French J = Jour = Day).
The syntax "# ##0 J" is invalid for Excel while "# ##0 €" works.
What is the trick ??
Thanks for any answer

 

[Claus Busch]

Hello,

Am Fri, 25 Jan 2013 09:55:52 +0100 schrieb Dudule:

Hello, I would like to display in a cell "26 J" (in French J = Jour = Day).
The syntax "# ##0 J" is invalid for Excel while "# ##0 ?" works.

try:
0 "J"


Regards
Claus Busch

 

[joeu2004]

I would like to display in a cell "26 J" (in French J = Jour = Day).
The syntax "# ##0 J" is invalid for Excel while "# ##0 €" works.
What is the trick ??

Try:

# ##0 \J

Note the back-slash before J.

The problem is: in your regional version of Excel, J probably has a special
meaning in formats, just as D does in my version.

 

[Dudule]

Hello,
Thanks for all your answers, but the two suggestions, link to the following
display:
0 J
The number (for example 26) is not taken into account (should be 26 J)
Thanks for any other suggestions....


"Dudule" a écrit dans le message de groupe de discussion :
[email protected]...

Hello, I would like to display in a cell "26 J" (in French J = Jour = Day).
The syntax "# ##0 J" is invalid for Excel while "# ##0 €" works.
What is the trick ??
Thanks for any answer

 

[Albert]

Hi
What is the language of your EXCEL ?
albert

 

[Dudule]

Hello,
Found a trick:
###" J"
or
0" J"
Displays ==> 26 J
If any blank space is between the "0" or the last "#" and the first quote
(") then "0 J" is displayed.
Many thanks for your help.

"Dudule" a écrit dans le message de groupe de discussion :
[email protected]...

Hello,
Thanks for all your answers, but the two suggestions, link to the following
display:
0 J
The number (for example 26) is not taken into account (should be 26 J)
Thanks for any other suggestions....


"Dudule" a écrit dans le message de groupe de discussion :
[email protected]...

Hello, I would like to display in a cell "26 J" (in French J = Jour = Day).
The syntax "# ##0 J" is invalid for Excel while "# ##0 €" works.
What is the trick ??
Thanks for any answer

 

[Albert]

Hi
"Dudule" <[email protected]> a écrit dans le message de

If you want to display the name of the day in french you can use
=CHOOSE(WEEKDAY("31 July
2007"),"Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi ","Samedi")

albert