Right way to increase value by 0,01 each row

[delta]

H I am trying to increase the value of a cell (value 200,00 (two hundred GBP)) in the first cell
and then increase the amount by 0,01 if I drag down the collumn by dragging the bottom right of the selected cell(s). e.g 200,00 200,01 200,02 200,03 → drag down until 300,00.

I have run into multiple issues when trying to do this:
even though I format the cells as currency and set 2 decimals as the column/cell setting , when dragging down the column everything works fine until it hits 200,99… instead of going to 201,00 which, I expected since its formatted as currency it jumped to 200,100… I tried different things but I have the feeling that my workarrounds are make things more difficult and I must me missing something…

advice appreciated,
regards,
Ben

[anon73440385]

it jumped to 200,100…

if that happens you don’t have , (comma) as a decimal delimiter in your locale and in fact you are dealing with (left aligned) text but not numbers (and hence not currency). Please check and show: Tools -> Options -> Language Settings -> Languages

[anon73440385]

Hello,

Method 1:

• Cell A1: Enter 200,00
• Cell A2: Enter =A1+0,01
• Drag down cell A2
• Optional Select column A and use Data -> Calculate -> Formula to Value

Method 2: (preferred due to large number of cells in your use case)

• Select column A
• Sheet - Fill Cells -> Fill Series ...
  Start value 200
  End value 300
  Increment 0,01

Note(s)
This solution works for locales having , (comma) as decimal delimiter. If you are using a locale having . (decimal point) decimal delimiter you need to adapt accordingly.

According to your problem description, you are dealing with Text data and not numerical values - see the following animation:

Hope that helps.