Hi Tony
in excel if you want 4/1 to appear as 4/1 you need to treat it as text, so
either format the cell first as text (format / cells - number tab, choose
text) before entering the number OR when entering the number type a ' in
front of it (e.g. '4/1) - it won't show and won't print but will force excel
to belive you :)
sorry can't help with the second question, i don't get "time" in excel.
Cheers
JulieD
"Tony Moffat" wrote in message
...
Numbers that I enter appear as 01-Apr when I really want them to be 4/1
(four to one)..
and..
time entered as 01:06:34 I want to convert to
66.34 seconds....
any help for pensioner, Thanks
Tony
|