excel format

F

foxes1

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

In the accounting format, a dollar sign precedes each value in a list. This should not be the case. The dollar sign should only show at first entry and total.

Please help
 
C

CyberTaz

You're right - that's why you shouldn't apply the *same* formatting to all
rows or all columns :) Use Currency formatting for the appropriate
rows/columns but use Comma formatting for the cells in between.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How cancel $ in column? 2
Ledger template shows $ when internationalsetting is £ 4
Ledger Sheets 2
error with exel 1
cannot enter a long series of numbers without excel changing them. 3
Formatted cells change when reopen the sheet 3
default currency 3
Cursor 2

Top