LinkBack URL
About LinkBacks
Hi,
For some strange reason I can't format it to normal financial format.
Normal it should look like € 234,05
But now it looks like € 234,05,000
Can someone help? And tell me what happened?
You can find the attachment.
Hi,
For some strange reason I can't format it to normal financial format.
Normal it should look like € 234,05
But now it looks like € 234,05,000
Can someone help? And tell me what happened?
You can find the attachment.
Check your custom formatting. You have it set to add trailing zeros after the value is entered.
Spread the love, add to the Rep
"None of us are as smart as all of us."
It appears to me that whoever created the number format code for those cells used the same character (","?) as both the thousands separator and the decimal separator. I think this caused Excel to decide that you intend it to simply display those characters ("0,00") at the end of the number (#,##). I think that, if you put the correct thousands separator in the appropriate place in the number format code ("#.##0,00"?), then you will get the display you want.
Originally Posted by shg
Huh, I don't get it.
Hey guys,
I got it working. Lol. It took me since yesterday.
Thanks all ya.
Take care!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks