RSS

Change numbers to Arabic in excel.

10 Jan
  1. Select the area of the cells that you need to change
  2. Press Ctrl+1 using keybard
  3. Go to Customes and type this code: [$-2000000]#,##0.00
  4. This will give you comma seperate and 2 decimals

[$-2000000]#,##0.00 this will make numbers separated by comma and 2 decimal points.

[$-2000000]0 this will just convert the numbers to Arabic. No decimal and no commas.

 
Leave a comment

Posted by on January 10, 2021 in Windows

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

 
%d bloggers like this: