 |
 | 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 / April 2005format of cell
I am trying to type in 2-26 in a cell, I have the cell as `general` format but it keeps jumping back to custom and giving 46413. Is there something else I should be doing? thanks Hi Try entering it with a ' first ie '2-26 Excel is trying to help you by interpreting what you enter as something else (probably a date). Alternatively, format the cell as text before you enter the data.  SignatureAndy. >I am trying to type in 2-26 in a cell, I have the cell as `general` format > but it keeps jumping back to custom and giving 46413. > Is there something else I should be doing? > > thanks I went to format the cell and chose text.. then typed the info and it came out 2-26 as a label > I am trying to type in 2-26 in a cell, I have the cell as `general` format > but it keeps jumping back to custom and giving 46413. > Is there something else I should be doing? > > thanks Thanks Andy that worked. > I am trying to type in 2-26 in a cell, I have the cell as `general` format > but it keeps jumping back to custom and giving 46413. > Is there something else I should be doing? > > thanks Thanks for the feedback. Glad to help! SignatureAndy. > Thanks Andy that worked. > [quoted text clipped - 4 lines] >> >> thanks |
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.