ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how can i change dollar sign to rupee sign in sales invoice (https://www.excelbanter.com/excel-discussion-misc-queries/142243-how-can-i-change-dollar-sign-rupee-sign-sales-invoice.html)

vishal kohli

how can i change dollar sign to rupee sign in sales invoice
 
Hi I am facing problem ,while making sales invoice i m getting sign of Dollar.
But i want it in indian currency.

Toppers

how can i change dollar sign to rupee sign in sales invoice
 
Excuse my ignorance but if you want Rp 1234 then look at Format
Cells=Currency==Indonesian which has the "Rp" symbol.

"vishal kohli" wrote:

Hi I am facing problem ,while making sales invoice i m getting sign of Dollar.
But i want it in indian currency.


James Silverton

how can i change dollar sign to rupee sign in sales invoice
 
Toppers wrote on Thu, 10 May 2007 05:36:01 -0700:

T "vishal kohli" wrote:

?? Hi I am facing problem ,while making sales invoice i m
?? getting sign of Dollar. But i want it in indian currency.

T Excuse my ignorance but if you want Rp 1234 then look at
Format
T Cells=Currency==Indonesian which has the "Rp" symbol.



I don't think that will work, at least not with my version of
Excel 2002 since the path to Indonesian does not seem to be
present. However, the dollar sign in one of the standard Custom
formats could be replaced with Rp, AFAIK.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not


Toppers

how can i change dollar sign to rupee sign in sales invoice
 
Good idea! (I have Excel 2003).

"James Silverton" wrote:

Toppers wrote on Thu, 10 May 2007 05:36:01 -0700:

T "vishal kohli" wrote:

?? Hi I am facing problem ,while making sales invoice i m
?? getting sign of Dollar. But i want it in indian currency.

T Excuse my ignorance but if you want Rp 1234 then look at
Format
T Cells=Currency==Indonesian which has the "Rp" symbol.



I don't think that will work, at least not with my version of
Excel 2002 since the path to Indonesian does not seem to be
present. However, the dollar sign in one of the standard Custom
formats could be replaced with Rp, AFAIK.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not




All times are GMT +1. The time now is 09:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com