Hi

Names of worksheets

WS1 Finance Bank Transfer (all Calculations done on this page)
WS2 Giro Account Formula =SpellNumber('Finance Bank Transfer'!F17)
WS3 PMG Account Formula =SpellNumber('Finance Bank Transfer'!C30)

Is this correct

Thanks

Mark


"Norman Jones" wrote:

Hi Mark,

This Function brings back No Pounds And No pence for worksheet 3
However i need the pounds to come up with no pence.


Dave's Function modifications worked for me.

I could reproduce your results if (a) the cell contained a zero value (or
was empty) *and* (b) the function was called without stipulating a value of
False for Dave's second parameter, e.g.:

=spellnumber(A1,FALSE)

Another possibility is that calculation is set to manual and the cell is
returning an historic value.

---
Regards,
Norman