Thread: Cell format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kim K Kim K is offline
external usenet poster
 
Posts: 47
Default Cell format

I have created a chart for my daughter for a science experiement. All 12
data entries are fine for all categories except one. when I type in 29:04 as
in 29 minutes 04 seconds, I get all kinds of weird things happen, I have set
the cell to be mm:ss but apparently it looks at 29 as hours and creates a
time and or date. This is critical for the scoence data to be graphed out
and imperative I create this cell to reflect 29 minutes 04 seconds as all the
other times are already graphed.

How can I get this cell to reflect correctly?
--
Thanks in advance,
Kim