Table number formating.

[Josh]

Is there any way to programatically format table cells? For instance,
programatically make column "A" have a $#.00 or #.00 format.

 

[Chuck]

There isn't a way to set the number format of the column but you can enter
your numbers as "formulas":

Dim strYourNumber As String

'Use code to set value of strYourNumber eg:
strYourNumber = Inputbox("Enter number")

Selection.InsertFormula Formula:="=" & strYourNumber, NumberFormat:="#.00"