Domino & Notes error

Cannot convert text to a number

What it means

Notes expected a number but got text, either from the user or inside a formula.

Common causes

  • Letters or symbols typed into a number field or number setting
  • A formula doing arithmetic on a text field
  • Imported data where numbers were stored as text

Quick fixes

  1. If you are a user, re-enter the value as a plain number
  2. In formulas, convert with @TextToNumber and check the result with @IsError
  3. Fix the field type on the form, or clean up the stored values with an agent

Need a hand with this?

Paste your exact message into What's That Error? for a plain-English explanation, or get in touch. I've been supporting Domino and Notes for 28 years.

Disclaimer

The errors, causes and fixes on this site are carefully researched, drawing on HCL documentation and 28 years of hands-on Domino and Notes experience. Every environment is different, though, and a solution that works in one may not be right for yours. Exact wording can also vary between Domino and Notes versions.

This information is general guidance only and is provided without warranty of any kind. Always back up your data and test changes on a non-production system first. To the extent permitted by law, Bruinsma Services Pty Ltd accepts no responsibility or liability for any loss, damage, downtime or other consequence arising from use of this information. For advice specific to your environment, please contact me.