|
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
.
|