I have 1000000 in a cell and if i click on "Use 1000 seperators on" it will come as 10,00,000. If I divide it with 1000 and the result should come to 10,00 instead of 1,000. Now what should i have to do get as this.
I have 1000000 in a cell and if i click on "Use 1000 seperators on" it will come as 10,00,000. If I divide it with 1000 and the result should come to 10,00 instead of 1,000. Now what should i have to do get as this.
The '000 (thousand separator) in Excel is based on the Regional settings of the OS. Form above, I gather that you have typical settings for India - Thousands, Lakhs, Crores and hence a separator after 3,2,2,2 digits .... and so on.
See this thread from another forum on something similar - thousand-separator-how-2-change.html.
HTH!
Thank you. I got the logic
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks