Cell Format

  • Thread starter Thread starter Dudule
  • Start date Start date
D

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
 
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.
Click to expand...

try:
0 "J"


Regards
Claus Busch
 
Dudule said:
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 ??
Click to expand...

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.
 
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
 
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
 
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
 
Back
Top