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.
The NUMBERSTRING function
![](http://sumproduct-4634.kxcdn.com/img/containers/main/./image1-1707215558.png/72cea6c4366c69f0048ce734c2cbdb55.jpg)
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)
where:
- 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.
![](http://sumproduct-4634.kxcdn.com/img/containers/main/./image2-1707215621.png/de653d5e87409e70c478feed753b9cf1.jpg)
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.