Dear All,
I am a new user in the FORUM........
We have prepared a EXCEL worksheet with various interlinked sheets.
The Excel sheet was prepared in MS EXCEL-2007 and send via mail and numbers were formated in Millions with the regional settings digit grouping 123,456,789...(snapshot is attached).
But the receipient complaints that the excell sheets received in Thousands/Lakhs. Could you please advise what could be wrong. Is it the issue with receipients system format or sender's system.
Request alll of you to send me your valuable guidance to troubleshoot this issue.
Thanks and Regards,
Nucleus.
Hi,
Does this site http://exertia.wordpress.com/2006/04...ores-in-excel/ help you?
Regards
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star iconat the bottom left of my post.
Is there some more links which will give more clear results.
"There is an easier way to change the global settings from Settings > Control Panel > Regional Settings > Numbers, but that will affect all your Excel sheets and the change will be visible only on your system and not on your files which you send to others." -- which is the number format ?.
Hi,
I don't understand your question. The site I pointed to you shows how you need to format individual cells to show Indian currency units.
You should not be formatting cells as numbers but using the custom format. I'm assuming you know how to do this.
Regards
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star icon
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks