before:
V 2013
I am using fill series to fill cells below.
expected:
V 2013
V 2013
V 2013
result:
V 2013
V 2,013
V 2,013
I found only http://productforums.google.com/forum/#!topic/docs/kv1kDdzoYOY - without any useful information.
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communitybefore:
V 2013
I am using fill series to fill cells below.
expected:
V 2013
V 2013
V 2013
result:
V 2013
V 2,013
V 2,013
I found only http://productforums.google.com/forum/#!topic/docs/kv1kDdzoYOY - without any useful information.
Use the keyboard shortcut for Fill Down: ctrl+D. Make sure to highlight the range you want to fill beforehand. You can either use shift+click with the mouse, or shift+down with keyboard to highlight the range.
This seems like a bug in Google Spreadsheets. I was able to replicate when using mouse to drag the bottom right corner, but ctrl+D works fine.