Thanks for the try on this but I was able to figure it out. It IS a
bit quirky but it works. Basically you apply the "PasteSpecial"
function with a multiply Operation. You have to have a "1" in a cell
somewhere for this to work  (I just put it in and hid the row). The
VBA code looks like this:

Private Sub FormFieldName_Change()
Worksheets("SheetName").Activate
Activesheet.Range("CellYouAreEnteringTo").Value = FormFieldName
Activesheet.Range("CellYouHave1in").Select
Selection.NumberFormat = "General"
Selection.Copy
Activesheet.pastespecial Paste:=xlPasteAll,
Operation:=xlMultiply, SkipBlanks:=False, Transpose:=False
Selection.NumberFormat = "FormatYouWantNumbersToBe"