<div>
check the second spreadsheet there must be a compile error in the code
</div>


check the second spreadsheet there must be a compile error in the code

<div>
Thanks guys!<br />
<br />
I am a little embarrassed, that I could not figure that out myself. Truth is I am mostly doing VBA in Access, so I was totally locked in the perception, that I had to use the TEXT function and not the FORMAT.<br />
<br />
Everything is fine now thanks!
</div>


Thanks guys!

I am a little embarrassed, that I could not figure that out myself. Truth is I am mostly doing VBA in Access, so I was totally locked in the perception, that I had to use the TEXT function and not the FORMAT.

Everything is fine now thanks!

<div>
<div class="content wysiwyg-content">
How can it be, that in one spreadsheet I have no problems with using the TEXT function, e.g. <br />
st= TEXT(i,&quot;001&quot;) - or simply typing ?TEXT(i,&quot;001&quot;) in the immediate window, while in another spreadsheet I am told &quot;Sub or Function not defined&quot;<br />
<br />
In Tools&gt;References I have exactly the same references..
</div>
</div>


How can it be, that in one spreadsheet I have no problems with using the TEXT function, e.g. 
st= TEXT(i,"001") - or simply typing ?TEXT(i,"001") in the immediate window, while in another spreadsheet I am told "Sub or Function not defined"

In Tools>References I have exactly the same references..

text function in vba excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.