Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
Trouble formatting a cell
Posted by Horacio on December 10, 2001 9:43 AM
Hello everyone,
I'm having trouble formatting a cell... when I input A1-11-1318 or above, the format goes to date no matter what I do. I try to format it as text or general and it goes back to date. Can anyone tell me how to fix this problem?
P.S. If I input A1-11-1317 or lower, I have no problem, but anything above that, goes to date format.
Thanks in advance.
Re: Trouble formatting a cell
Posted by Tom on December 10, 2001 12:08 PM
Not sure what the problem is, try starting with an equals sign.
Re: Trouble formatting a cell
Posted by Horacio on December 10, 2001 1:05 PM
Thanks for the response Tom,
I don't need any formulas... I just need to type "A1-11-1324" in the cell, but it formats it as date.
How come ? That's not a *valid* date. (NT)
Posted by Juan Pablo G. on December 10, 2001 5:06 PM
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.