You could try a nested field

{ IF "{ MERGEFIELD myfield }" = "" "" "{ ={ MERGEFIELD
myfield }+1000000 }" }

(all the {} need to be the special field braces you can insert using
ctrl-F9.

That won't work if your field can contain non-numeric text, e.g. " " or
"abc" :-)

Peter Jamieson
"Boots" wrote in message
...
Hi.
Can I tweak a mergefield contents so that if the field is blank it stays
blank and if it contains a number it adds 1000000 to it?
thanks