how to enter numbers like 8:0 or 2:8 in a cell

[Raju]

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

 

[Roger Govier]

Hi

Format>Cells>Number>Custom> #":"#

--
Regards
Roger Govier

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

 

[Roger Govier]

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

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

 

[Raju]

Hi Roger,

Thanks for the quick response. However i do not find the option #":"# under
the custom list.

Using Excel 2007

 

[Roger Govier]

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

Hi Roger,

Thanks for the quick response. However i do not find the option #":"#
under
the custom list.

Using Excel 2007



__________ 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

 

[Sam Wilson]

You have to type it in yourself...

Hi Roger,

Thanks for the quick response. However i do not find the option #":"# under
the custom list.

Using Excel 2007

 

[Raju]

Thank You!! Roger and Sam.

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



__________ Information from ESET Smart Security, version of virus signature database 4531 (20091022) __________

The message was checked by ESET Smart Security.

http://www.eset.com



.