Change format in model (Howto)
Sometimes you want to change format throughout the complete model. For example, in parts of the EU you want comma decimal seperator instead of dot as is default. Or, if you start with an accelerator, you might want to remove USD as currency symbol. This is how you can do it in five simple steps: 1) Go to Settings -> Modules -> Line Items 2) Select the complete column Format 3) Copy and paste the complete column into an excel sheet 4) Search and replace the format code line in excel, see some examples below how to change from US settings to Swedish/EU. 5) Copy the updated column from excel and paste it into the Format column in Anaplan (make sure you stand on the first cell in the column before pasting)
If you need to find out what to search for and what to replace it with, just copy the cell in the format column in Anaplan before and after the change you want to apply. Then do steps 1-5 above using the complete lines as search and replace expressions. I hope this will save you some time!