View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default Converting time as 7.5 (which represents 7:30 AM) to 0730

And it even states it right there that it's workbook options.
Thanks all again for all your patience.

Steve

"Gord Dibben" wrote:

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 ?