View Single Post
  #5  
Old May 10th, 2010, 10:06 PM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default How to globally insert $ signs in front of all cell refereces?

This helps to change cell references in what manner?


Gord Dibben MS Excel MVP

On Mon, 10 May 2010 11:46:01 -0700, trip_to_tokyo
wrote:

EXCEL 2007

"If anyone knows of a way to change the entire spreadsheet to insert the $
signs into each cell reference"

1. Click on, "cell" to left of letter A and above the number 1 to highlight
whole Worksheet.

2. Home tab / Font group / click on arrow in lower right hand corner /
Format Cells should launch / Number tab / Currency - in here select the
dollar sign that you want and hit OK.

3. Now type any number into any cell and it will be pre-fixed with the
dollar sign.

If my comments have helped please hit Yes.

Thanks.