Difference in formats(send/receive)

**Nucleus** · 09-20-2011, 02:47 AM

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.

**Richard Buttrey** · 09-20-2011, 04:43 AM

Hi,

Does this site http://exertia.wordpress.com/2006/04...ores-in-excel/ help you?

Regards

**Nucleus** · 09-20-2011, 04:53 AM

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 ?.

**Richard Buttrey** · 09-20-2011, 06:26 AM

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