Fixed Decimal point
Thanks but that did not seem to work. I entered it exatly hoy you typed it.
Selection.NumberFormat = "$0.00;-$0.00;-"
Once with out the word selection.
What I end up with when I put what you said in is that code in every cell
instead of the numbers? Any ideas what I could be doing wrong.
"Patrick Molloy" wrote in message
...
select th erange or cells that you want to format, under the menu Format /
Cells..
choose Currency and check that the $ is the symbol and 2 decimals is
selected
In code
Selection.NumberFormat = "$0.00;-$0.00;-"
or
Range("A1:G20").NumberFormat = "$0.00;-$0.00;-"
"dave" wrote:
I know This is an excel newsgroup But I cant seem to find the answer to
my
question anywhere so I figured I would ask it here.
I am using Quattro pro and I want to be able to fix a few cells decmal
points like you can do on an adding machine. Example if I were to type
1234
it would automaticly show up as 12.34. Ideally I would like it to show up
as
$12.34.
I was using Excell at work and found something that moved the decimal
over
for me, but it did it for the whole page not just where I needed it.
Thanks
|