need help formating a cell

  • Thread starter Thread starter Rama
  • Start date Start date
R

Rama

i am trying to type 2-1-1 in a cell and want the next cell to be 2-1-2 and so
on. But my cell keeps coming up a 36893. i have tried formating cell to
general and custom.
 
Pre-format cells as Text

Enter 2-1-1

Drag/copy down


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Peculiar default cell format 1
Excel Need Countifs Formula Help 0
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Comparison of columns using Conditional Formatting 3
Conditional Formatting 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top