View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
raju raju is offline
external usenet poster
 
Posts: 14
Default 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