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 do I get the money sighn $ on my sums in Excel?

I can do sums in the cells but I want to show the cash value and although it
adds I wont do it with money sighn $.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default How do I get the money sighn $ on my sums in Excel?

hi
format as currency'
right click the cell. from the popup, click format cells
on the number tab, in catagory box, click currency.

regards
FSt1


"Mel5612" wrote:

I can do sums in the cells but I want to show the cash value and although it
adds I wont do it with money sighn $.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 563
Default How do I get the money sighn $ on my sums in Excel?

Go to the required cell; click the currency tool on the toolbar in Excel
2003; in Excel 2007 it it on the Home tab
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Mel5612" wrote in message
...
I can do sums in the cells but I want to show the cash value and although
it
adds I wont do it with money sighn $.


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
How do I type negative money in excel? Ugly Betty Excel Discussion (Misc queries) 4 May 18th 23 11:47 AM
Microsoft Money and Excel tevers2003 Excel Discussion (Misc queries) 3 May 12th 08 05:56 PM
adding money amounts in excel Holden Caulfield New Users to Excel 1 September 25th 06 03:52 PM
Excel and MS Money davidbird Excel Discussion (Misc queries) 2 September 4th 05 05:56 PM
How do I import Excel into Microsoft Money Tax Help Excel Discussion (Misc queries) 2 March 21st 05 09:53 PM


All times are GMT +1. The time now is 08:56 AM.

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"