custom format cells

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

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
>

You have a reply at your original post.

puiuluipui wrote:
>
> 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

--

Dave Peterson

Thanks Dave . You are the best.Thanks again. see ya.