I have created a table for following payments. So each row has, few cells formated as currency.
Then I open the same file on other computer (other excel), and format of number changed from $11.000,00 to $11.000.0.00 or something.
How can I solve this?
Thanks
Sounds like the default currency formatting is different on the second machine. Either change it to make them the same, or apply a custom format on the first machine.
Entia non sunt multiplicanda sine necessitate
Hi,
Of course I have tried to change it on the second machine to, and when I go to Format Cells menu, and select Currency, the format shown there is like $22.000.0.00 . Even if I manage to change it in custom, it's still the same on the worksheet.
What else can I try?
My suggestion was that you apply a custom format on the FIRST machine, where it already looks correct. So select the existing cells with their correct formats, change the format to Custom, and leave what appears in Type exactly as it is.
The difference is that the SECOND machine should now use the custom format applied on the first.
Last edited by shg; 11-14-2008 at 11:21 AM.
What about Start > control Panel > Regional Settings, is that set to the correct format?
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks