Why doesn't this work??

[Dermot81]

Basically, what I'm trying to do is convert the contents of a cell, both values AND formats, into a string. For example, the value of .08, formatted as a percent looks like 8.0%. I want the contents of this cell to be made into a string so it reads "8.0%" I tried doing this in VBA, it spits out the correct value, but it isn't in string format. Any help guys?

format = Sheets("Array Data").Range("D12").NumberFormat
Sheets("Converge").Range("A5").Select
ActiveCell.Value = Application.WorksheetFunction.text(Sheets("Array Data").Range("D12"), format)

[Dermot81]

Nevermind, figured it out. The cell has to be formatted as text first, before the value is put in. I added this (Selection.NumberFormat = "@") to the VBA code and now it works fine.