Posted to microsoft.public.excel.worksheet.functions
|
|
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
|