Dear sir,

I would like to know the formula / function for writing the series of numbers (eg. 1 to 1000000) in words in Excel work sheet. For example, if in cell A1 the number 1 is there, in cell B1 I should get "ONE", if in cell A1 number 2 is there, in cell B1 I should get "TWO" and so on up to 1000000.

Thanking you,

VASUDEVAN

[email protected]

I would like to know the formula / function for writing the series of numbers (eg. 1 to 1000000) in words in Excel work sheet. For example, if in cell A1 the number 1 is there, in cell B1 I should get "ONE", if in cell A1 number 2 is there, in cell B1 I should get "TWO" and so on up to 1000000.

Thanking you,

VASUDEVAN

[email protected]

## Comment