entering numbers in the cells in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

when entering numbers into a cell, how do you change the format from it
automatically changing the numbers inputted into date formats ? for example:
7-3 gets changed to 3-Jul.
 
The easiest way is to precede the 7-3 with an apostrophe ('). Then Excel will
not modify it. You could also preformat the cells to text, which will stop Excel
from changing them.
 

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

Conditional formatting in Excel 2010 2
Data auto edit 6
Default number format in Excel 1
How do I stop Excel from copying date format from cell above? 2
Numbers change to a date format 3
Overlapping Cells 4
Enter number (data) into cells but want to show different data 3
excel changes date 2

Back
Top