Formula doesn't copy correctly

S

sara

When I use autofill, the formula doesn't copy correctly. I don't get an
error, yet it doesn't display the results. In the cells I autofill, I get the
following: $ -
Why is this? How come the autofill displays this?
 
L

Luke M

Example of your formula please?

With the limited info given, a random guess is that the cells you are
filling to are formatted to accounting, and the result of formula is 0.
 

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

Autofill Date in Word 15.33 for Mac 0
autofill results appear as "$ -" with no error, why? 2
SUM FORMULA- skipping every seventh row 1
Using IF and VLOOKUP for range of cells 5
VBA to autofill from relative location 2
Copy values for every nth cell 7
Copy addition formula of non-consecutive horizontal cells 2
How can I edit the default column autofill formula? 0

Top