Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i format
value of $21,480 and gain/loss of $4,080 to currency style format with
decimal poistions in excell |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
Adding time in 24 hour format to produce hours in decimal format | Excel Worksheet Functions | |||
Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
how to format excel format to text format with separator "|" in s. | New Users to Excel |