 |
 | 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 / September 2006Formatting help needed
I have started an extremely basic sheet and only want to put opening times of buildings, eg.. 2 - 5 but cannot get rid of 2-May. I've tried using general in category but still get 2-May instead of 2 - 5. Can you help?  SignatureLynne Mawson Manchester Try changing the formatting to Text. You will need to retype it in. > I have started an extremely basic sheet and only want to put opening times of > buildings, eg.. 2 - 5 but cannot get rid of 2-May. I've tried using general > in category but still get 2-May instead of 2 - 5. Can you help? One way would be to use a formula and then copy/paste to value =MONTH(G6)&" - "&DAY(G6) SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com >I have started an extremely basic sheet and only want to put opening times >of > buildings, eg.. 2 - 5 but cannot get rid of 2-May. I've tried using > general > in category but still get 2-May instead of 2 - 5. Can you help? Hi Lynne, You can put a single apostrophe ' before expressions that are potentially 'mathematical' e.g. they start with a number or dash (minus sign) if you would like them to be treated as text: '2 - 5 instead of 2 - 5 Anthony > I have started an extremely basic sheet and only want to put opening times of > buildings, eg.. 2 - 5 but cannot get rid of 2-May. I've tried using general > in category but still get 2-May instead of 2 - 5. Can you help? precede it with an apostrophe ' '2 - 5 SignatureHTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) > I have started an extremely basic sheet and only want to put opening times of > buildings, eg.. 2 - 5 but cannot get rid of 2-May. I've tried using general > in category but still get 2-May instead of 2 - 5. Can you help?
|
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.