ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   custom cells format (https://www.excelbanter.com/excel-discussion-misc-queries/43126-custom-cells-format.html)

puiuluipui

custom cells format
 
I want to format a cell so i can transform 1256453 in 125.56. How can i
format a cell so i can view first number as 125.56?
Thanks for your help.

Dave Peterson

You have a couple of replies to your other posts.

puiuluipui wrote:

I want to format a cell so i can transform 1256453 in 125.56. How can i
format a cell so i can view first number as 125.56?
Thanks for your help.


--

Dave Peterson

Sanjeev

Go to Format --Cell --Number--Custom

There you type

0.00,

You get the results as desire

Sanjeev Agarwal



"puiuluipui" wrote:

I want to format a cell so i can transform 1256453 in 125.56. How can i
format a cell so i can view first number as 125.56?
Thanks for your help.


puiuluipui

it's not what i wont. The result is 1256.45. i want to view it as 125.56.
Do you have another solution? thanks.

"puiuluipui" wrote:

I want to format a cell so i can transform 1256453 in 125.56. How can i
format a cell so i can view first number as 125.56?
Thanks for your help.


puiuluipui

??? sorry, i don't understand.Where can i find the solution?? What's the
solution? Thanks

"Dave Peterson" wrote:

You have a couple of replies to your other posts.

puiuluipui wrote:

I want to format a cell so i can transform 1256453 in 125.56. How can i
format a cell so i can view first number as 125.56?
Thanks for your help.


--

Dave Peterson


Dave Peterson

If you post multiple messages to several newsgroups, you'll have to go back to
each newsgroup to see if you have responses.

If you only post to one newsgroup (or post one message with several newsgroups
in the header), then your life would be easier.



puiuluipui wrote:

??? sorry, i don't understand.Where can i find the solution?? What's the
solution? Thanks

"Dave Peterson" wrote:

You have a couple of replies to your other posts.

puiuluipui wrote:

I want to format a cell so i can transform 1256453 in 125.56. How can i
format a cell so i can view first number as 125.56?
Thanks for your help.


--

Dave Peterson


--

Dave Peterson


All times are GMT +1. The time now is 03:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com