I need to fill the data in the following format - 1.1, 1.2, 1.3, 1.4, 1.5, 2.1, 2.2, 2.3, 2.4, 2.5, 3.1, 3.2....100.1, 100.2, 100.3, 100.4, 100.5 Cannot figure out how to do it. Any help is highly appreciated!
I need to fill the data in the following format - 1.1, 1.2, 1.3, 1.4, 1.5, 2.1, 2.2, 2.3, 2.4, 2.5, 3.1, 3.2....100.1, 100.2, 100.3, 100.4, 100.5 Cannot figure out how to do it. Any help is highly appreciated!
In A1:A5 manually enter:
1.1
1.2
1.3
1.4
1.5
Enter this formula in A6 and copy down as needed:
=A1+1
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Many thanks! So simple and smart!
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks