{"id":6629,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/estnum\/"},"modified":"2021-02-26T08:09:05","modified_gmt":"2021-02-26T08:09:05","slug":"isnumber","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/isnumber\/","title":{"rendered":"ESTNUM"},"content":{"rendered":"

Description de la fonction<\/h2>\n

La fonction ESTNUM()<\/code>, \u00e9galement appel\u00e9e ISNUMBER()<\/code> en anglais, est fr\u00e9quemment utilis\u00e9e dans Microsoft Excel et Google Sheets pour d\u00e9terminer si une valeur donn\u00e9e est un nombre. Elle retourne TRUE si la valeur est num\u00e9rique, et FALSE sinon. Cette fonction est particuli\u00e8rement utile pour la validation de donn\u00e9es et le nettoyage de grands ensembles de donn\u00e9es.<\/p>\n

Syntaxe<\/h2>\n

La syntaxe de la fonction ESTNUM()<\/code> est la suivante :<\/p>\n

ESTNUM(valeur)<\/code><\/pre>\n
Le param\u00e8tre ‘valeur’ repr\u00e9sente la donn\u00e9e \u00e0 \u00e9valuer. Il peut s’agir d’une r\u00e9f\u00e9rence de cellule, d’une formule, ou m\u00eame d’un nombre saisi directement dans la fonction.<\/p>\n
Exemples simples<\/h2>\n
    \n
  • ESTNUM(5)<\/code> renvoie TRUE<\/strong>, car 5 est un nombre.<\/li>\n
  • ESTNUM(\"Bonjour\")<\/code> renvoie FALSE<\/strong>, car \u00ab\u00a0Bonjour\u00a0\u00bb est du texte et non un nombre.<\/li>\n
  • ESTNUM(A1)<\/code> o\u00f9 A1 contient le chiffre 2023 retourne TRUE<\/strong>.<\/li>\n
  • ESTNUM(A2)<\/code> o\u00f9 A2 contient le mot \u00ab\u00a0Excel\u00a0\u00bb retourne FALSE<\/strong>.<\/li>\n<\/ul>\n
    Sc\u00e9narios pratiques d’utilisation<\/h2>\n
    Sc\u00e9nario 1: Filtrage des entr\u00e9es num\u00e9riques<\/h3>\n
    Imaginez que vous avez une liste de valeurs dans la colonne A et vous d\u00e9sirez identifier uniquement celles qui sont num\u00e9riques pour les copier dans une autre colonne. La mise en \u0153uvre serait la suivante :<\/p>\n\n\n\n\n\n\n
    Colonne A<\/th>\nColonne B<\/th>\n<\/tr>\n
    102<\/td>\n=ESTNUM(A1)<\/td>\n<\/tr>\n
    Excel<\/td>\n=ESTNUM(A2)<\/td>\n<\/tr>\n
    300.5<\/td>\n=ESTNUM(A3)<\/td>\n<\/tr>\n
    Texte123<\/td>\n=ESTNUM(A4)<\/td>\n<\/tr>\n<\/table>\n
     <\/p>\n
    Cette technique permet de filtrer et de manipuler facilement les valeurs num\u00e9riques en marquant les cellules A1 et A3 comme TRUE et A2 et A4 comme FALSE.<\/p>\n
    Sc\u00e9nario 2: Validation de donn\u00e9es<\/h3>\n
    Consid\u00e9rons que vous d\u00e9veloppiez un formulaire demandant aux utilisateurs de saisir leur \u00e2ge. L’utilisation de la fonction ESTNUM()<\/code> peut servir \u00e0 confirmer que les entr\u00e9es sont num\u00e9riques :<\/p>\n
    Si ESTNUM(C2) Alors 'Continuer avec le traitement Sinon 'Afficher un message d'erreur demandant \u00e0 l'utilisateur d'entrer un nombre valide<\/code><\/pre>\n
    Cette m\u00e9thode assure que le formulaire ne traitera que les valeurs ad\u00e9quates, \u00e9vitant ainsi les erreurs dans les calculs ou analyses ult\u00e9rieurs.<\/p>\n
     Dans ces illustrations, la fonction `ESTNUM()` facilite la v\u00e9rification et la validation des donn\u00e9es de mani\u00e8re efficace, assurant la fiabilit\u00e9 des op\u00e9rations et des rapports bas\u00e9s sur ces donn\u00e9es.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie VRAI si l\u2019aRgument valeuR RepR\u00e9sente un nombRe<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[319],"tags":[],"class_list":["post-6629","post","type-post","status-publish","format-standard","hentry","category-informations"],"acf":[],"yoast_head":"\nFonction ISNUMBER (ESTNUM) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction ISNUMBER (ESTNUM) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/fr\/isnumber\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction ISNUMBER (ESTNUM) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction ISNUMBER (ESTNUM) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/isnumber\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:09:05+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction ISNUMBER (ESTNUM) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/isnumber\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/isnumber\/\",\"name\":\"Fonction ISNUMBER (ESTNUM) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:09:05+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction ISNUMBER (ESTNUM) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/isnumber\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/isnumber\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/isnumber\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Informations\",\"item\":\"https:\/\/functiontranslator.com\/fr\/informations\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"ESTNUM\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction ISNUMBER (ESTNUM) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction ISNUMBER (ESTNUM) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/fr\/isnumber\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction ISNUMBER (ESTNUM) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction ISNUMBER (ESTNUM) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/isnumber\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:09:05+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction ISNUMBER (ESTNUM) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/isnumber\/","url":"https:\/\/functiontranslator.com\/fr\/isnumber\/","name":"Fonction ISNUMBER (ESTNUM) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:09:05+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction ISNUMBER (ESTNUM) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/isnumber\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/isnumber\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/isnumber\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Informations","item":"https:\/\/functiontranslator.com\/fr\/informations\/"},{"@type":"ListItem","position":3,"name":"ESTNUM"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6629","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6629"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6629\/revisions"}],"predecessor-version":[{"id":29640,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6629\/revisions\/29640"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6629"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6629"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6629"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}