Conversion in EXCEL Numeric to Text

N

News

Hi,

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

Thank you

Arnold
 
P

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
 
Top