|
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 |
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 |
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 |
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 |
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 |
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 |
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 . |
| All times are GMT +1. The time now is 10:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com