brion dublin
Thread Starter
- Joined
- May 4, 2007
- Messages
- 80
OK, It was here I first learned about ASAP utilities, wow I love that thing...
I use it all the time..
here's a problem I can't figure out how to use ASAP to fix
PROBLEM:
E.G.
I write a formula like [=O11-Q11] into R11. and it works for row 11 just great.
out of my 500 rows I need this to apply to about 50 various rows.
So I drag the formula down all 500 rows.
I get my answer in all 50 that I need.
but the other 450 looks Messy!
How do I remove the 0.00 & # characters from this column?
If I do a ASAP charter removal and try to remove "0" and "." from the list it will effect my
answers in my 50 good prices.
thank you
Brion
I use it all the time..
here's a problem I can't figure out how to use ASAP to fix
PROBLEM:
E.G.
I write a formula like [=O11-Q11] into R11. and it works for row 11 just great.
out of my 500 rows I need this to apply to about 50 various rows.
So I drag the formula down all 500 rows.
I get my answer in all 50 that I need.
but the other 450 looks Messy!
How do I remove the 0.00 & # characters from this column?
If I do a ASAP charter removal and try to remove "0" and "." from the list it will effect my
answers in my 50 good prices.
thank you
Brion