Please note javascript is required for full website functionality.


A to Z of Excel Functions: The NUMBERSTRING Function

4 March 2024

Welcome back to our regular A to Z of Excel Functions blog.  Today we look at the NUMBERSTRING function.



Like DATESTRING, NUMBERSTRING seems to have been a function created for backward compatibility with Lotus 1-2-3 and other similar programs.  It is thought the syntax of the function is of the form

NUMBERSTRING(number, format)


  • number is the number to be converted
  • format is the argument to specify the conversion, e.g. to the Chinese number format.

It appears to be no longer operational but is still recognised in Excel, viz. 

This function is presented for completeness only.


We’ll continue our A to Z of Excel Functions soon.  Keep checking back – there’s a new blog post every business day.