View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JennyN JennyN is offline
external usenet poster
 
Posts: 2
Default How do I set up Excel to display time as typed

I want to be able to format excel so that when I type 9.00 in a cell it
displays as 9.00 am. Every time i use time format and type it in it displays
as 12.00 am - why?