Dollar sign

J

John Bahran

Does anybody know how to put the dollar sign on the far left and the
number in the far right? Like $ 45.
Would appreciate any help.
 
L

Lady Layla

Format cells as Accounting , select $ and the # of Decimals you need


: Does anybody know how to put the dollar sign on the far left and the
: number in the far right? Like $ 45.
: Would appreciate any help.
 
H

hcj

The $ format button on the toolbar does this. Based on
the others' comments, the button invokes Accounting (
which I never knew - thanks Lady Layla and Andy B), so
there you have it!
 

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

Formatting Currency Without Any Special Characters 3
Dollar sign left justified - data right justified - large space 3
Copying a formula while leaving one cell fixed 1
Dollar sign alignment - Accounting vs Currency style 3
Concatenate & Number Formats 2
The letter "b" appears after the dollar sign 7
From Dollar ($) sign style to Dirhams (Dhs.) sign style 2
Align $ sign next to numbers 5

Top