Is there a way to not omit the leading zeros when downloading a saved search via CSV? I tried using formula text but it still does not work. (can download in xls but csv is preferred)

I think you can use a numeric fomrula and use TO_NUMBER({field}).

When you perform the search, are you seeing

000123

? If so, your downloaded CSV will also contain

000123

. If this is the case, it's probably because you're opening the CSV in an application, like Excel, that detects the content of column/cell and converts it into a number. If you want to stick with excel, you have a couple of options. All of which involve some kind of import wizard and selecting to not auto-detect data types. • The legacy text import wizard • The new (power query based) import wizard

Thanks!