Prevent Excel Worksheet from displaying formula bar 6

[aug4570]

Hi,

Does anyone know how to prevent the formula bar from being viewed by the user? The protect worksheet does not work for this feature.

Also anyone have a formula to convert a calendar date to a Julian date?

Thanks

 

[aug4570]

Additional clarification: I want to prevent the user from acessing Tools/Options and selecting the formula bar status.

Thanks again.

 

[acron]

If, before protecting the worksheet, you Format Cells, select the Protection tab and check the Hidden checkbox, any formulas should be invisible once the worksheet is protected.

A.C.

 

[aug4570]

Thanks Acron,
That works.

Now does anyone have a formula that will convert a calendar date to a julian date?

 

[DeLaMartre]

Hello Aug,

The following formula will convert a standard Excel date in A1 to a Julian Date:

=RIGHT(YEAR(A1),2)&TEXT(A1-DATE(YEAR(A1),1,0),"000&quot

I hope this helps.

-Bob in California

 

[Hasit]

To insert the current day in "Julian" format, with a two-digit year, enter the following formula.

=TEXT(TODAY(),"yy&quot&TEXT((TODAY()-DATEVALUE("1/1/"&TEXT(TODAY(),"yy&quot)+1),"000&quot

To insert the current day in "Julian" format, with a four-digit year, enter the following formula.

=TEXT(TODAY(),"yyyy&quot&TEXT((TODAY()-DATEVALUE("1/1/"&TEXT(TODAY(),"yy&quot)+1),"000&quot

To convert the date in cell A1 to "Julian" format, with a two-digit year, enter the following formula.

=TEXT(A1,"yy&quot&TEXT((A1-DATEVALUE("1/1/"&TEXT(A1,"yy&quot)+1),"000&quot

To convert the date in cell A1 to "Julian" format, with a four-digit year, enter the following formula.

=TEXT(A1,"yyyy&quot&TEXT((A1-DATEVALUE("1/1/"&TEXT(A1,"yy&quot)+1),"000&quot

 

[aug4570]

Thanks Bob and Hasit, that helped me. Appreciate the info, your help, and definitely this valuable site!