Let's say you've just calculated your monthly revenue and want to export the results to include in some report. 

However, the values in your total revenue column look like this:

1000 etc

and you want them to look like this:

£1000 etc

This is straight forward to achieve in Trevor. 


  1. Click the new column button.
  2. Tick the replace existing column option.
  3. Type the following expression: "£" + revenue_column_name
  4. Click done.

All done! 


Having trouble?

We're on standby to help! To chat with us, click the blue Intercom button in the bottom right of Trevor's interface.

Did this answer your question?