How to increment number

[Abhijeet]

Hi

In Excel 4.1,4.2........... to 4.20 how to do this in formula & how to wright code in VBA

 

[iferror]

Hang on...you want to have something like 4.1 - 4.2 - 4.3 ------ 4.10 - 4.11 ------ 4.19 - 4.20 ?

Wouldn't it be better to have 4.01 - 4.02 and so forth?
How do you intend to tell 4.1 from 4.10?

As far as VBA, you only need a FOR loop

For ind = 1 to 20
yourtext = "4." & indx
Next


Formula
Type 4.1 in cell A1
Type this formula in A2 and copy down
="4." & RIGHT(A1;LEN(A1)-2)+1

 

[Somendra Misra]

Hi Abhijeet,

I think It should be 4.01, 4.02, .... 4.20. If so you can use below formula:

=4+MOD(ROWS(A$1:A1)/100,1)


Regards,

 

[Abhijeet]

Hi Abhijeet,

I think It should be 4.01, 4.02, .... 4.20. If so you can use below formula:

=4+MOD(ROWS(A$1:A1)/100,1)


Regards,

I give only example 4.01 can u please give me any number can give same like this with formula

 

[Somendra Misra]

@Abhijeet

Replace the 4 with a choice of your number OR refrence the 4 to a cell and use the cell in the formula as shown below.

=$B$1+MOD(ROWS(A$1:A1)/100,1)

Where in B1 is the number of your choice.

Regards,

 

[SirJB7]

Crossposted at: http://chandoo.org/forum/threads/access-vba-problem.15691/#post-95192
User being warned again.

 

[Abhijeet]

Hi

I have data i want sort this data with number format please tell me how to do this

 

[Somendra Misra]

@Abhijeet

Apply autofilter to the column and than sort A-Z. Isn't this solving your problem?

Regards,

 

[NARAYANK991]

Hi Abhijeet ,

See this file.

Narayan

 

[Abhijeet]

Thanks Narayan