Correct formatting for currency in excel

Question

Im trying to get Rp1.000 with the exact value 1000, but the result always showing Rp1000.0.00

I didn't know what exaclty the problem was, after following the formats that i have on the internet. Weirdly when i input 60000 into the cell, its shown Rp 600000, i tried in other laptop and pc, but the result is different using the same format.

Answer 1

Hi Planet!

I'm Jen, and I'd be happy to help you out with this issue.

Just to clarify, do you just want to remove the thousand separator? Would you be able to copy and paste the format code here so I could try it on my end? Thanks.

Best Regards!

Jen :)

Answer 2

It is far too complicated to recreate such a scenario. And if it does not match yours, then our solution will not work for you.

For this kind of requests, please create a sample file with the layout of your original file, filled with sample data and colored cells with the expected result.

At best make a copy of your original file and anonymize the necessary data. For this please download this file
https://www.dropbox.com/s/rkfxuh85j5wyj9y/modAnonymize.bas?dl=1
Open your Excel file
Right-click on the sheet tab
Choose "View Code"
Press CTRL-M
Select the downloaded file and import
Close the VBA editor
Select the cells with the confidential data
Press Alt-F8
Choose the macro Anonymize
Click Run

Upload it on OneDrive (or an other Online File Hoster of your choice) and post the download link here.
https://support.office.com/en-us/article/Share-OneDrive-files-and-folders-9fcc2f7d-de0c-4cec-93b0-a82024800c07

Then we can look at the file and try to find a solution. Thank you for your understanding.

Andreas.