Would this be ok to use them for the field calculator in ArcGIS 9.3 ? See here MS Excel VBA Functions

Or should I fix them in MS Excel and save as a file and then use the join with the shapefile or file geodatabase. Will this work ? Will ArcGIS read it in table ?

Please advice as I am looking for information on how to use field calculator.


  • 3
    Some of those functions are built-in to VBA, some are specific to Excel. For examples of VBA functions available in the field calculator see: support.esri.com/en/knowledgebase/techarticles/detail/31807
    – blah238
    Oct 18, 2011 at 2:47
  • Can anyone tell me how to use it to force the decimals remove and replace with the comma. Here I have a column with acres like this 506320.0750 and I want this (506,320) to display permanmently ?
    Oct 18, 2011 at 18:39
  • Please ask a separate question for this.
    – blah238
    Oct 18, 2011 at 19:00
  • I posted in a separate question.
    Oct 18, 2011 at 19:20

2 Answers 2


Here is a technical document describing some of the basic VBA calculator functions, with links to some short walk-throughs. And here is some narrative (with examples) on using the Field Calculator and VBA.

Remember that using VBA in the field calculator is only valid for 9.3.1 and not 10 (which uses python and VBScript).


You can open field calculator and use a function like...
ltrim [my_field]
Then in field calculator you will see a save button.
This will save a file that can be reloaded in caclulator.
You can view this file in notepad (or other text editor).
As blah238 said the knowledgebase article will help show what can and can't be used.

NOTE: You will only be able to use field calculator on the left side of your join (unless you create a dbf file with an oid and join that).
Esri join

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.