Get ready for our upcoming product updates and releases with these webinar sessions.
Important notice for users submitting Individual Tax Returns on ITM  please click here for further information.

CaseWare Working Papers | What to do when my cents translate into Rands during my import from Excel?

Published:  22/11/2016
How do I resolve my figures in cents converting to Rands during the import from Excel into CaseWare and how do I change the currency format or decimal symbol?


Did you know the regional settings of your machine can also influence the import process?
The data will not import correctly if the Number and Currency settings are not the same.

Two alternate approaches to resolve this are as follows:

Ensure that the Currency and Number settings for the Region and Language options are the same on your machine (this will be under the Additional settings).

User-added image

Alternatively you can use the following approach:

You can use the ‘Regional Settings’ field on the Advance Specification screen during the import.
Untick the box on the Advance Specification screen during the import and specify the decimal and grouping symbols as per your Excel file being imported:

User-added image

The Windows default Currency settings will have overridden to match the Numbers settings.
(Popularity = 0/100, Rating = 0.0/5)

Didn't find what you were looking for?

Watch a video

Check out our helpful video guides

Contact Support

Contact our support team
CaseWare and the CaseWare logo, are registered trademarks of CaseWare International Inc. and are licenced for use to CaseWare Africa and Adapt IT. © 2018. All rights reserved.

For more information, visit

If you would like to keep up to date with the latest CaseWare Africa news:

For South Africa clients follow us on:
LinkedIn   Twitter   Facebook   YouTube  

For Nigeria, Kenya, Mauritius and the rest of Africa you can connect with us on:
LinkedIn   Twitter   Facebook   YouTube
Copyright © 2019 | All Rights Reserved