Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I would like to know how to format a "cell''. I want to type a number,
example: 4,6,8,10,12,14....ect. But I want it to show on the cell as 4/64,6/64,8/64,10/64,12/64.....ect. Could sombody help me with this problem? I tried things on Edit and Format cells, but I cant find the right format. |
#2
![]() |
|||
|
|||
![]()
Really depends on what you want the cell to equate to.
If you want the value to equal the number you entered, try this custom format: General"/64" -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "wiskeyjruiz" wrote in message ... I would like to know how to format a "cell''. I want to type a number, example: 4,6,8,10,12,14....ect. But I want it to show on the cell as 4/64,6/64,8/64,10/64,12/64.....ect. Could sombody help me with this problem? I tried things on Edit and Format cells, but I cant find the right format. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
difficulty changing cell format | Excel Worksheet Functions | |||
Format a cell with numbers and user defined text | Excel Discussion (Misc queries) | |||
Custom format that shows blank cell if another cell is empty | Excel Discussion (Misc queries) | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
How do I unhide the cell format function in Excel 2000 | Excel Worksheet Functions |