| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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. |
|
#4
|
|||
|
|||
|
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. |
|
#5
|
|||
|
|||
|
??? 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 |
|
#6
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
| Cell will not format numbers correctly for a 13 digit custom barc. | Excel Worksheet Functions | |||
| custom list with accounting format | Excel Discussion (Misc queries) | |||
| format cells | Excel Worksheet Functions | |||
| Min/Max formulas using cells with date format | Excel Worksheet Functions | |||
Linear Mode
