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

  • Thread starter Thread starter Raju
  • Start date Start date
R

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
 
Hi

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

--
Regards
Roger Govier

Raju said:
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
Click to expand...

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

The message was checked by ESET Smart Security.

http://www.eset.com
 
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 said:
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
Click to expand...

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

The message was checked by ESET Smart Security.

http://www.eset.com
 
Hi Roger,

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

Using Excel 2007
 
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 said:
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
Click to expand...

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

The message was checked by ESET Smart Security.

http://www.eset.com
 
You have to type it in yourself...


Raju said:
Hi Roger,

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

Using Excel 2007
Click to expand...
 
Thank You!! Roger and Sam.

Roger Govier said:
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



.
Click to expand...
 
Back
Top