Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire
Veuillez sélectionner un problème
Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
h2so4
bonsoir,
essaie la fonction format()
Format Function Example This example shows various uses of the Format function to format values using both named formats and user-defined formats. For the date separator (/), time separator (:), and AM/ PM literal, the actual formatted output displayed by your system depends on the locale settings on which the code is running. When times and dates are displayed in the development environment, the short time format and short date format of the code locale are used. When displayed by running code, the short time format and short date format of the system locale are used, which may differ from the code locale. For this example, English/U.S. is assumed.
MyTime and MyDate are displayed in the development environment using current system short time setting and short date setting.
Existe t-il l'équivalent de la fonction TEXTE en VBA ?
Merci de vos conseils.
Cordialement.
Excel...lent
bonsoir,
essaie la fonction format()
Format Function Example
This example shows various uses of the Format function to format values
using both named formats and user-defined formats. For the date separator
(/), time separator (:), and AM/ PM literal, the actual formatted output
displayed by your system depends on the locale settings on which the code is
running. When times and dates are displayed in the development environment,
the short time format and short date format of the code locale are used.
When displayed by running code, the short time format and short date format
of the system locale are used, which may differ from the code locale. For
this example, English/U.S. is assumed.
MyTime and MyDate are displayed in the development environment using current
system short time setting and short date setting.
Format Function Example This example shows various uses of the Format function to format values using both named formats and user-defined formats. For the date separator (/), time separator (:), and AM/ PM literal, the actual formatted output displayed by your system depends on the locale settings on which the code is running. When times and dates are displayed in the development environment, the short time format and short date format of the code locale are used. When displayed by running code, the short time format and short date format of the system locale are used, which may differ from the code locale. For this example, English/U.S. is assumed.
MyTime and MyDate are displayed in the development environment using current system short time setting and short date setting.
