Hi Homer

FormatCellsNumberCustom000000000000
Then as you paste values to the cell, they will be padded to 12 digits
with a negative sign in front where necessary

--
Regards

Roger Govier


"Homer" wrote in message
...
Hi

I am downloading data in to excel & need to format an amount field in
to a
fixed 12 character field i.e. prefix with zeros to fill the 12 chars.
NOW
comes the tricky bit, if the value is negative I need the (-) minus
sign
prior to any leading zeros.

Help Please!