Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

excel numbering help


  • Please log in to reply

#1
geekstome

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

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

geekstome

    Member

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

#4
Vino Rosso

Vino Rosso

    Visiting Staff

  • Visiting Consultant
  • 235 posts
You're welcome :)
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP