custom format cells

[puiuluipui]

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

 

[Ed Ferrero]

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/

 

[Dave Peterson]

You have a reply at your original post.

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]

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