Custom format for Value in Crore

[Ketan_ashiyani]

Dear Team,

We need to require Custom format for Value in Crore

Ex. 1,00,00,000
Requirement 1.00 Cr

 

[felixstraube]

Like this?

Book2
	A	B
1	123,45,67,890.00	123.46 Crs %
2	-123,45,67,890.00	-123.46 Crs %
Sheet1

Cell Formulas
Range	Formula
B1:B2	B1	=A1
A2	A2	=A1*-1

Then write the format like this:

0.00,,," Crs"%;[Red]-0.00,,," Crs"%;-

And then (before closing the format window) position you cursor first before the last % sign and press Ctrl+J, and then the just before the % sign to the left and press Ctrl+J

 

[Sanjeev1976]

Since you require the amount in brackets, you can use the solution provided by felixstraube by using the below format

0.00,,," Crs"<Ctrl+J>%;[Red](0.00,,,)" Crs"<Ctrl+J>%

 

[Joe4]

Ketan_ashiyani,

Please Note: In the future, when marking a post as the solution, please mark the post that actually contains the solution. Please do not mark your clarification question as the solution (I have removed this).

When a post is marked as the solution, it is then shown right underneath the original question so people viewing the question can easily see the question and solution in a single quick glance without having to hunt through all the posts.