Change Date Format
I'm new to Excel 2007. My problem is that I do not know how to stop Excel
from automatically converting text to a date format. For example, when I enter data in a cell such as: Smith v Jones 06-91, Excel automatically changes 06-91 to Jun-91. Data entered as Smith v Jones 06-3412 remains 06-3412. How do I stop Excel from automatically changing 06-91 to Jun-91? "06" does mean June but it should stay as "06". Thanks. |
Change Date Format
How do I stop Excel from automatically changing 06-91 to Jun-91?
You can either precede the input: 06-91 with an apostrophe ('), or pre-format the input cells as text beforehand. .. when I enter data in a cell such as: Smith v Jones 06-91, Excel automatically changes 06-91 to Jun-91. I don't know/have xl2007, but think the above doesn't happen in xl2003 (my ver) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Ann" wrote: I'm new to Excel 2007. My problem is that I do not know how to stop Excel from automatically converting text to a date format. For example, when I enter data in a cell such as: Smith v Jones 06-91, Excel automatically changes 06-91 to Jun-91. Data entered as Smith v Jones 06-3412 remains 06-3412. How do I stop Excel from automatically changing 06-91 to Jun-91? "06" does mean June but it should stay as "06". Thanks. |
All times are GMT +1. The time now is 06:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com