Excel groups digits in pairs not by groups of three. Example 23 45 67,89 not 234 567,89
Changing anything in "format cells" doesn't help. The type chosen there is correct and should give grouping by three digits.
Could anyone please help to solve this issue?
Try
Right click on cell or press control+1, you'll get a window named format cell->> go to number tab->> choose custom ->>>put below the try ## ## ## ,## this and then ok.
Perhaps this would help you.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Are there any macros attached producing the unwanted format?
What does this produce ISTEXT(A1) where A1 is your cell? It should be FALSE.
When you say the format there is correct, what does that mean? What exactly is the format?
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks