number and text format

[dosaril]

hello 

could you please advise me i have field called project number, it contains both (number and text), as showing below:

i try to use= num(project Number],, '###0') , but that only show numbers without text 

what should i add to show both 

thank you 

[marcus_sommer · Accepted solution]

Try: alt(num([project Number], '###0'), [project Number]) 

[dosaril]

thank you