INSERTING INFORMATION IN A CELL

W

WINGCO

WHERN I INSERT IN CERTAIN FIELDS INSTEAD OF THE TYPED DATA BEING THERE, WHEN
/i CLICK OUT A DATE APPEARS INSTEAD
 
G

Gord Dibben

This is Excel being helpful.

If it looks like a date Excel will store as a date.

8-8-06 looks like a date to Excel.

1/3 looks like a date to Excel.

Pre-format the cells as Text or precede your data with an apostrophe.


Gord Dibben MS Excel MVP
 
Top