Jump to content

Welcome to Geeks to Go - Register now for FREE

Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

How it Works Create Account
Photo

excel numbering help

Started by geekstome , Aug 03 2009 10:16 PM

  • Please log in to reply

#1
geekstome
Posted 03 August 2009 - 10:16 PM

geekstome

    Member

  • Member
  • PipPip
  • 24 posts
hello

how to make the row become autonumbering in decimal format?
mine got problem when it reached 1.10 , it will become 2.1 instead of 1.9,1.10,1.11
also , i can't key in 1.10 , excel will auto numbered it to 1.1 , how to stop this
picture as below
help pls

Posted Image

Edited by geekstome, 03 August 2009 - 10:19 PM.

  • 0

Advertisements

#2
Vino Rosso
Posted 04 August 2009 - 12:16 AM

Vino Rosso

    Visiting Staff

  • Visiting Consultant
  • 235 posts
Right-click on column letter and select Format cells
Click on the Number tab, ensure Decimal Places = 2, and click OK

Start the numbering 1.01, 1.02, 1.03, etc.
Highlight the three cells and drag down to auto-number.
  • 0

#3
geekstome
Posted 04 August 2009 - 12:36 AM

geekstome

    Member

  • Topic Starter
  • Member
  • PipPip
  • 24 posts
that's it ! thanks so much!!
  • 0

#4
Vino Rosso
Posted 04 August 2009 - 01:23 AM

Vino Rosso

    Visiting Staff

  • Visiting Consultant
  • 235 posts
You're welcome :)
  • 0
Back to Office · Next Unread Topic →




Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

  1. Geeks to Go Community
  2. → Software
  3. → Office

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP