Reformatting information in a cell

M

mvan24

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.
 
G

Gord Dibben

Preformat the cells to Text or precede the 8/58 with an apostrophe.

'8/58

Gord Dibben Excel MVP
 
Top