On Fri, 11 Nov 2005 10:21:57 GMT, "bramruis via OfficeKB.com" <u15176@uwe
wrote:

Ron,

What I found out now is that when an amount is 66.60 Excel will cut of the
trailing zero and the result of your formula will be 66.F
I should be 66.6{
I could change the format of the cell to text but then the negative amounts
are no longer recognized.

Any ideas?

Thanks,

Bram.

I did not realize you would be dealing with decimals.

That can be handled.

But how is the cell formatted? Is the formatting fixed or variable?

In order to have a trailing zero after the decimal, it must be formatted with
some known number of decimal places.

If the cell is formatted with two trailing decimal places,
and the number stored is 91.995,
and the number displayed is 92.00,
what do you want the translation to be?

In other words, do you want the translation to be based on the number stored,
or the number displayed?


--ron