Use TEXT(cell,format) to deal with the formatted result in a formula.

Jerry

bramruis via OfficeKB.com wrote:

Ron,

The values in the cells are (currency) amounts with 2 decimals. The problem I
think lies in the fact that although Excel is showing e.g. 99.20 in the cell
the actual value shown in the Formula bar is 99.2 and that's why the zero is
not converted but the 2 is.
I hope you can help me out on this one.

Bram.


Ron Rosenfeld wrote:

Ron,


[quoted text clipped - 9 lines]

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