Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel Database
Name: recordamus Date: June 11, 2009 at 13:14:34 Pacific OS: XP Pro SP3 Build 260 CPU/Ram: AMD Athlon XP2100 1.RAM 1.5Gb Subcategory: Microsoft Office
Comment:
Could anyone possibly tell me how can I stop Excel from automatically changing "5 - 9" into date format of "05-Sep" when entered into a cell?
Name: DerbyDad03 Date: June 11, 2009 at 13:57:57 Pacific
Reply:
Put an apostrophe in front of it to tell Excel that it should remain as text:
'5 - 9
0
Response Number 2
Name: recordamus Date: June 11, 2009 at 14:04:39 Pacific
Reply:
Dear DerbyDad
Thank-you so much. It works a treat! You have no idea how much hair I have pulled out trying to sort this problem. Incidentally, are you in Derby, UK? I am an ex-pat living in Dorset, if you are. Very many thanks, once again. I really am most grateful to you.
0
Response Number 3
Name: DerbyDad03 Date: June 11, 2009 at 19:24:26 Pacific
Reply:
re: are you in Derby, UK
No. The Derby in DerbyDad03 has nothing to do with where I live.
Summary: I have created a simple letter and use Excel as the data source. When I merge the document on my PC at home it creates the correct number of letters to correspond with the number of records However, w...
Summary: I need to create mailing labels from an excel database. I assume I make that my data source and pull it into word but my question is how do I only use selected contacts? The database is well over...
Summary: **** FURTHER COMMENT **** I am just wondering if there is a maximum size of excel doc that word will merge to? If I copy and paste a small section of the excel database to a new doc with a new name t...
0 
Help! Lost document!
