troubleshooting Question

Custom number ("Tape measure" )format for Excel 2003

Avatar of jtencha
jtencha asked on
Windows XPMicrosoft ExcelSpreadsheets
6 Comments1 Solution1029 ViewsLast Modified:
I want to use Excel 2003 to draft up a preliminary floor plan for a room. I want to add dimensions on the
length and width of the perimeter of the layout such that the numbers are displayed as follows (in inches):
0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 1.0, 1.1, 1.2, 1.3, 1.4, 1.5, 1.6, 1.7, 1.8, 1.9, 1.10, 1.11, 2.0, 2.1, 2.2.......3.0...etc

As you can see, for every 12 inches,  the number resets back to the next whole one foot measurement.

I need to be able to enter the first number, and then have the capability to click and drag the numbers across the screen so that excel will automatically fill the numbers in this format for me.

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros