View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
David McRitchie David McRitchie is offline
external usenet poster
 
Posts: 903
Default Change hh:mm to hh.mm

That would really mess things up, don't do it.
If you must do something along those lines see Chip Pearson's page.
Time quick entry in
http://www.cpearson.com/excel/DateTimeEntry.htm

You should also know that time represents a fraction of a day and
you can read about that more on Chip's site, or on mine
http://www.cpearson.com/excel/datetime.htm
and at (there isn't really much overlap)
http://www.mvps.org/dmcritchie/excel/datetime.htm
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"JR Hester" wrote in message ...
Is there a simple way change teh hour: minute separator in time formatted
cells(columns) to accept the decimal instead of the:? Data entry would be so
much simpler and quicker using the decimal point.
Suggestions appreciated

Thanks