You can set the value to whatever you want it to be, but if you set it to $123,456.00, it'll be stored as a String. If you want it to be numeric, then you have to set the value of the cell to a numeric value (123456), then apply the formatting to it.
On Fri, Nov 21, 2014 at 4:34 PM, Blake Watson <[email protected]> wrote: > Is it possible, given a cell with (e.g.) a currency format, to pass a value > like "$123,456.00" to set it? Or must we always use 123456? > > -- > > *Blake Watson* > > *PNMAC* > Application Development Manager > 5898 Condor Drive > Moorpark, CA 93021 > (805) 330.4911 x7742 > [email protected] <[email protected]> > www.PennyMacUSA.com <http://www.pennymacusa.com/> >
