Reformatting information in a cell

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

Guest

I am trying to type 8/58 in a cell. This is exactly how I want it to appear.
Excell keeps changing it to Aug-58. This is not what I want. I have tried
to format the cell as general but it keeps chaning to custom.
 
Preformat the cells to Text or precede the 8/58 with an apostrophe.

'8/58

Gord Dibben 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

how do i enter a negative number sequence with spaces in excel 1
Rows to Columns 3
Workbook cells won't hold formatting in Office 2007 2
dashes around cells 3
Add 1 to a cell 2
Excel pivot tables - specific expand/collapse buttons visibility 1
Entering 'GTi' but I get 'Gti' ! 2
Excel Typed text appears in wrong cell 0

Back
Top