| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to enter numbers like 8:0 or 2:8 in a cell
Hi Team,
I am not able to find the format option to enter numbers like 8:0 , 8:2 in a particular cell. I am able to get the view using the time format option for a cell, but how do i enter this ratio format?? Please advice |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to enter numbers like 8:0 or 2:8 in a cell
Hi
FormatCellsNumberCustom #":"# -- Regards Roger Govier "Raju" wrote in message ... Hi Team, I am not able to find the format option to enter numbers like 8:0 , 8:2 in a particular cell. I am able to get the view using the time format option for a cell, but how do i enter this ratio format?? Please advice __________ Information from ESET Smart Security, version of virus signature database 4531 (20091022) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4531 (20091022) __________ The message was checked by ESET Smart Security. http://www.eset.com |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to enter numbers like 8:0 or 2:8 in a cell
Posted too quickly
I should have added that having set the format, just enter 80 for 8:0 or 82 for 8:2 -- Regards Roger Govier "Raju" wrote in message ... Hi Team, I am not able to find the format option to enter numbers like 8:0 , 8:2 in a particular cell. I am able to get the view using the time format option for a cell, but how do i enter this ratio format?? Please advice __________ Information from ESET Smart Security, version of virus signature database 4531 (20091022) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4531 (20091022) __________ The message was checked by ESET Smart Security. http://www.eset.com |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to enter numbers like 8:0 or 2:8 in a cell
Hi Roger,
Thanks for the quick response. However i do not find the option #":"# under the custom list. Using Excel 2007 "Roger Govier" wrote: Posted too quickly I should have added that having set the format, just enter 80 for 8:0 or 82 for 8:2 -- Regards Roger Govier "Raju" wrote in message ... Hi Team, I am not able to find the format option to enter numbers like 8:0 , 8:2 in a particular cell. I am able to get the view using the time format option for a cell, but how do i enter this ratio format?? Please advice __________ Information from ESET Smart Security, version of virus signature database 4531 (20091022) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4531 (20091022) __________ The message was checked by ESET Smart Security. http://www.eset.com |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to enter numbers like 8:0 or 2:8 in a cell
Hi Raju
No, it will not be there, you need to create it yourself. Underneath the word Type, is a small rectangular white pane which will have the word General as default. Click in that pane and type #":"# then OK That will create a new Custom type for you, which will then appear in the list of Custom types. -- Regards Roger Govier "Raju" wrote in message ... Hi Roger, Thanks for the quick response. However i do not find the option #":"# under the custom list. Using Excel 2007 "Roger Govier" wrote: Posted too quickly I should have added that having set the format, just enter 80 for 8:0 or 82 for 8:2 -- Regards Roger Govier "Raju" wrote in message ... Hi Team, I am not able to find the format option to enter numbers like 8:0 , 8:2 in a particular cell. I am able to get the view using the time format option for a cell, but how do i enter this ratio format?? Please advice __________ Information from ESET Smart Security, version of virus signature database 4531 (20091022) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4531 (20091022) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4531 (20091022) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4531 (20091022) __________ The message was checked by ESET Smart Security. http://www.eset.com |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to enter numbers like 8:0 or 2:8 in a cell
You have to type it in yourself...
"Raju" wrote: Hi Roger, Thanks for the quick response. However i do not find the option #":"# under the custom list. Using Excel 2007 "Roger Govier" wrote: Posted too quickly I should have added that having set the format, just enter 80 for 8:0 or 82 for 8:2 -- Regards Roger Govier "Raju" wrote in message ... Hi Team, I am not able to find the format option to enter numbers like 8:0 , 8:2 in a particular cell. I am able to get the view using the time format option for a cell, but how do i enter this ratio format?? Please advice __________ Information from ESET Smart Security, version of virus signature database 4531 (20091022) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4531 (20091022) __________ The message was checked by ESET Smart Security. http://www.eset.com |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to enter numbers like 8:0 or 2:8 in a cell
Thank You!! Roger and Sam.
"Roger Govier" wrote: Hi Raju No, it will not be there, you need to create it yourself. Underneath the word Type, is a small rectangular white pane which will have the word General as default. Click in that pane and type #":"# then OK That will create a new Custom type for you, which will then appear in the list of Custom types. -- Regards Roger Govier "Raju" wrote in message ... Hi Roger, Thanks for the quick response. However i do not find the option #":"# under the custom list. Using Excel 2007 "Roger Govier" wrote: Posted too quickly I should have added that having set the format, just enter 80 for 8:0 or 82 for 8:2 -- Regards Roger Govier "Raju" wrote in message ... Hi Team, I am not able to find the format option to enter numbers like 8:0 , 8:2 in a particular cell. I am able to get the view using the time format option for a cell, but how do i enter this ratio format?? Please advice __________ Information from ESET Smart Security, version of virus signature database 4531 (20091022) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4531 (20091022) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4531 (20091022) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4531 (20091022) __________ The message was checked by ESET Smart Security. http://www.eset.com . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The numbers I enter are changed when I leave the cell | Excel Discussion (Misc queries) | |||
| how to enter numbers on a cell | Excel Worksheet Functions | |||
| Enter multiple numbers in a cell so total shows when enter keypres | Excel Worksheet Functions | |||
| How to enter more than 20 digit numbers in one cell | Excel Discussion (Misc queries) | |||
| Why does date come up when I enter numbers in cell/Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
