Dollar Alignment

Cabel · Mar 5th, 2002, 05:31 PM

Hello,
I'm having trouble getting all the dollar signs to line up. I indent or move them left or right, but when i go to print preview, excel has moved them back. Help!!

Paul B · Mar 5th, 2002, 05:39 PM

Are your cells are formatted as accounting excel will line up the decimal places if this is the case

Mar 5th, 2002, 05:41 PM

Try formatting the cells like this :-

$* #,##0.00

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 5th, 2002, 05:31 PM	#1
Cabel New Member Join Date: Mar 2002 Location: Cabel Schoen Posts: 1	Hello, I'm having trouble getting all the dollar signs to line up. I indent or move them left or right, but when i go to print preview, excel has moved them back. Help!!

Mar 5th, 2002, 05:39 PM	#2
Paul B Board Regular Join Date: Feb 2002 Location: Georgia USA Posts: 544	Are your cells are formatted as accounting excel will line up the decimal places if this is the case

Mar 5th, 2002, 05:41 PM	#3
Guest Posts: n/a	Try formatting the cells like this :- $* #,##0.00