 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2006automatically format dates in a cell
Hi All, when I type a date into a cell, it automatically converts it to a date-time variable and formats it according to the system parameters. Is there any way I can turn this off? I don't want my date as a date time variable, nor do I want it to format to what the system format is. thanks stephan I'm not sure what a "date time variable" is, but if you want an XL date, but in the format you specify, preformat the cells with that format. If you don't want the date converted to an XL date at all, then preformat the cells as Text. They will then be left in whatever format you enter. > Hi All, > when I type a date into a cell, it automatically converts it to a date-time [quoted text clipped - 7 lines] > thanks > stephan date-time variable is equivalent to a float 3:15PM 17 July 2006 is equivalent to 38914.6354166667, which is the number of elapsed days since the stroke of midnight on 31 Dec 1899 thanks for your help, but preformating doesn't help me. I would like the autoformat turned off globally, so it would leave whatever date or time I type alone as text > I'm not sure what a "date time variable" is, but if you want an XL date, > but in the format you specify, preformat the cells with that format. [quoted text clipped - 15 lines] >> thanks >> stephan XL doesn't work that way, unfortunately. Unless you preformat as text, the parser gets first crack at the input, and will interpret it as a date. Your input format is lost. The alternative is to prefix all your entries with an apostrophe (') which tells the parser that what follows is text. > thanks for your help, but preformating doesn't help me. > I would like the autoformat turned off globally, > so it would leave whatever date or time I type alone as text
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.