Calc field number format

[kfok]

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?

[Lee Smith]

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

[comment]

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.