#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default how do i format

value of $21,480 and gain/loss of $4,080 to currency style format with
decimal poistions in excell
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,942
Default how do i format

hi
how are these numbers displayed on the sheet?

regards
FSt1

"How do I format this in my excel wrk sht" wrote:

value of $21,480 and gain/loss of $4,080 to currency style format with
decimal poistions in excell

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,346
Default how do i format

Hi,

Note sure what you mean by "decimal positions"

In general just click the $ button on the Home tab (2007) or the $ button on
the Formatting toolbar in 2003. Change the number of decimal places by
clicking the Increase or Decrease buttons also located on the Home tab or
Formatting toolbar.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"How do I format this in my excel wrk sht" wrote:

value of $21,480 and gain/loss of $4,080 to currency style format with
decimal poistions in excell

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
Lock Cell Format - Allow copy and paste of data without format change Chris12InKC Excel Worksheet Functions 2 May 9th 23 07:42 PM
Adding time in 24 hour format to produce hours in decimal format Hercdriver Excel Worksheet Functions 11 December 29th 09 02:06 AM
Need help with converting CUSTOM format/TEXT format to DATE format Deo Cleto Excel Worksheet Functions 6 June 2nd 09 08:14 PM
Replace million-billion number format to lakhs-crores format Sumit Excel Discussion (Misc queries) 1 December 9th 05 04:58 PM
how to format excel format to text format with separator "|" in s. azlan New Users to Excel 1 January 31st 05 12:57 PM


All times are GMT +1. The time now is 12:05 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"