Hi puiuluipui,

Assuming you want the number 1564524 to format as 156.45 the
custom format is "0.00," (enter everything between the quotes)

Ed Ferrero
http://edferrero.m6.net/


> How can i format a cell so 1.564.524 can be transformed in 156.45??
> I think in format cells > custom.
> But how?...thanks
>
>
> --
> puiuluipui
> ------------------------------------------------------------------------
> puiuluipui's Profile:
> http://www.excelforum.com/member.php...o&userid=26799
> View this thread: http://www.excelforum.com/showthread...hreadid=400596
>