Changes to the CIPC portal may cause submission issues. Click the Link to get the XBRL hotfix

Support will be closing at 12:00 (SAST) on Friday, 4 July 2025 due to internal training.

Windows 11 update might cause script errors in Caseware. Click the Link to get the hotfix

FAQ

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

Published:  14/06/2023
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?

  Answer:

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.
 
 
Rate this article: 
  (Popularity = 0/100, Rating = 0.0/5)

   Related Articles

How to import the trial balance from MS Excel to Caseware? How to import budget figures from Excel Caseware IDEA Tutorials: Importing An Excel Spreadsheet XBRL | How to change security settings for Caseware and when iXBRL "hangs" on CIPC validation view all...



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. © 2023. All rights reserved.

For more information, visit www.casewareafrica.com

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

LinkedIn   Twitter   Facebook   YouTube   Instagram   Google  

Copyright © 2025 | All Rights Reserved