dates

  • Thread starter Thread starter raiderrob1977-1
  • Start date Start date
R

raiderrob1977-1

how do i get excel from turning this number 2-2100 in to Feb-00?
 
Hi Rob,

Precede it with an apostrophe like this '2-2100
The apostrophe will show in the formula
bar but not in the cell..

or preformat the cell as text.

HTH
Martin
 
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

COUNTIF doesn't work 12
Excel How to calculate in excel number of open actions that expired (older then today) 0
Running total by date 2
Excel Help with dates 2
Work days 6
How to select the date? 4
How to change the year digit? 4
Why this paste result? 4

Back
Top