| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom number formats in TEXT function
I an using the TEXT function because I want to show a number in a cell
without that number being picked up in SUM functions on the worksheet. I want the text to display with a dollar sign on the far left of the cell, with a space for parentheses, and the number on the far right. I'm having trouble getting the formatting right -- the dollar sign shows up just in front of the number. My formula is =TEXT('Sheet2'!F16," _($* #,##0_);_($* (#,##0)") I thought that the asterisk followed by a space would push the dollar sign all the way to the left. What is wrong? Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Custom number formats in TEXT function
It only pushes it left if it is a number format.. -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=556542 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Custom number formats in TEXT function
Maybe this will perform as you wish............
=TEXT(Sheet2!F16,"$_(#,##0_);$(#,##0)") Vaya con Dios, Chuck, CABGx3 "MatthewB" wrote: I an using the TEXT function because I want to show a number in a cell without that number being picked up in SUM functions on the worksheet. I want the text to display with a dollar sign on the far left of the cell, with a space for parentheses, and the number on the far right. I'm having trouble getting the formatting right -- the dollar sign shows up just in front of the number. My formula is =TEXT('Sheet2'!F16," _($* #,##0_);_($* (#,##0)") I thought that the asterisk followed by a space would push the dollar sign all the way to the left. What is wrong? Thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Custom number formats in TEXT function
I don't understand. This is in a function called TEXT. It couldn't possibly
be in a number format. "Bearacade" wrote: It only pushes it left if it is a number format.. -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=556542 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Custom number formats in TEXT function
The $ will only be push to the LEFT if the cell format is used in a "number" format. If you use it in a Text function, it won't work.. -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=556542 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom number formats | Excel Worksheet Functions | |||
| custom number formats | Excel Worksheet Functions | |||
| Custom Number Format Text | Excel Discussion (Misc queries) | |||
| color coding custom number formats | Excel Discussion (Misc queries) | |||
| color coding custom number formats | Excel Discussion (Misc queries) | |||
Linear Mode
