I have two fields, one contains currency sign ($, Euro) and the other contains the amount. I merge the two fields as a calc field. I found that the number format was changed. For examples,

0.5 was changed to $.5

1,900 was changed to $1900

How do I keep the number format unchanged?

In version 6, calculations strip the trailing zero(s) from your numbers. This topic has come up many times in the past. You can search the Forum using keywords such as [color:blue] +number +format +zero ,

You can start with my post here.

HTH

Lee

Instead of creating a third, calculation, field of Currency & Amount (which BTW, is concatenation, not merging), try doing a real merge by putting the two original fields in a text block "<><>". Then select the block and format the number as decimal.