| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Dollar sign on left side of cell
Hi there. I've been trying to get the dollar sign to appear on the left hand side of each cell like this: $ 340,000 $ 560,000 I can only get it to appear right next to the number $340,000 $560,000 thanks for your help -- kurtis ------------------------------------------------------------------------ kurtis's Profile: http://www.excelforum.com/member.php...o&userid=27724 View this thread: http://www.excelforum.com/showthread...hreadid=472377 |
|
#2
|
|||
|
|||
|
Hi!
Set the cell format to Accounting. Biff "kurtis" wrote in message ... Hi there. I've been trying to get the dollar sign to appear on the left hand side of each cell like this: $ 340,000 $ 560,000 I can only get it to appear right next to the number $340,000 $560,000 thanks for your help -- kurtis ------------------------------------------------------------------------ kurtis's Profile: http://www.excelforum.com/member.php...o&userid=27724 View this thread: http://www.excelforum.com/showthread...hreadid=472377 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning left part of cell before a character | Excel Discussion (Misc queries) | |||
| Reverse the sign of a number in a cell | Excel Worksheet Functions | |||
| Reverse the sign of a number in a cell | Excel Worksheet Functions | |||
| Timestamp cell to left after update | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
