Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,339
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 182
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,339
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I am making a sales invoice but I can't change $ to £ sign Aleta Excel Discussion (Misc queries) 1 April 19th 06 03:46 PM
From Dollar ($) sign style to Dirhams (Dhs.) sign style Bohemianzzrek Excel Discussion (Misc queries) 2 April 4th 06 12:27 AM
can I change the $ sign to a £ sign in an MS template? tony Excel Worksheet Functions 1 January 2nd 06 07:31 PM
XL invoice replace the dollar sign with euro sign Pamela casares New Users to Excel 2 December 16th 05 09:21 PM
i want to change dollar sign to rands on excel invoice? sylvia Excel Discussion (Misc queries) 4 July 19th 05 11:14 AM


All times are GMT +1. The time now is 10:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"