Thread: Converting time as 7.5 (which represents 7:30 AM) to 0730
View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Converting time as 7.5 (which represents 7:30 AM) to 0730
Some ToolsOptions are global.....others are Workbook or Active Window only.

1904 date system is workbook only setting.


Gord Dibben MS Excel MVP


On Wed, 26 Sep 2007 12:29:00 -0700, Steve
wrote:

I set the tools/options to 1904 date system, but can I use that option only
for this workbook ? Changing tools/options is global, isn't it ?

Reply With QuoteReply With Quote