poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aram Mirzadeh <...@mbcli.com>
Subject Re: Insert a formatted value?
Date Fri, 21 Nov 2014 21:42:29 GMT
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 <blake.watson@pnmac.com>
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
> blake.watson@pnmac.com <melanie.petrosyan@pnmac.com>
> www.PennyMacUSA.com <http://www.pennymacusa.com/>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message