Can I reference a hundreds value of a number from a cell in Apple Numbers? For example, A1 has 12,345.00 I want A2 to output 345.00. Is this possible?
You can use the module function for this. In A2 enter

=MOD(A1;1000)