Conversion in EXCEL Numeric to Text

[News]

Hi,

I'am looking for VBA program inside EXCEL, which can convert numeric cells
to text.

Thank you

Arnold

 

[Pete_UK]

You could try this formula:

=TEXT(A1,"000000")

This will convert the number in A1 to a 6-digit text value, with
leading zeros as necessary.

Hope this helps.

Pete

 

[Bernard Liengme]

Or need you mean: 44 to forty-four? Is so then see
http://www.xldynamic.com/source/xld.xlFAQ0004.html
best wishes