Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

When I paste data with leading zeroes to a newly-opened blank Excel document, it strips out all leading zeroes.

Is there a way for me to open up a new instance of Excel (not from a template, I usually open up Excel by pressing Win+R keys and then typing Excel) with all cells formatted as text rather than general?

I tried having a template, but it's way too many mouse clicks.

Using Office 2007.

share|improve this question
add comment

2 Answers

up vote 3 down vote accepted

Presumably you want to do this some of the time and not all of the time.

If that is so,

  • create a new spreadsheet
  • format all its cells to text
  • save it (as read only) with a name such as "Excel-Text"
  • Put it, or a shortcut to it, to wherever you like to launch things from

and just launch it when you need it

share|improve this answer
    
Perhaps add to this process that one must do a "Save As..." each time to save the new document to a new file, rather than over-write the template. –  jmsmcfrlnd Dec 16 '09 at 20:55
1  
That is right - hence the suggestion to save as "Read Only" which will force a "Save as" –  Kije Dec 16 '09 at 20:59
    
Great idea, why didn't I think of that? :) Read-only feature really works well for this. Thanks! –  Eugene Dec 17 '09 at 19:51
add comment

To build on what Kije suggested, save your template file as "book.xlt". This is the default template for new Excel files. (Like Word's normal.dot file) Book.xlt needs to go in the XLSTART directory of either your user profile, or of the excel install itself. Exact locations vary based on OS and Office version. I have one in C:\users\MyName\AppData\Roaming\Microsoft\Excel and C:\Program Files\Microsoft Office\Office12\ for Windows7 and Office2007.

share|improve this answer
    
As I said in the answer -- I tried templates, but then I have to create a new Excel document from template, select the template (and scroll if I have too many templates), then create new document. That's too many clicks. –  Eugene Dec 17 '09 at 19:51
    
It should be noted that book.xlt is the default template. If saved in the appropriate place, ALL new documents are of that format, even if you don't explicitly choose a template. –  Christopher Karel Dec 17 '09 at 23:27
    
Ah, gotcha, sorry, I wasn't paying attention. This was exactly what I wanted, but I like Kije's answer better because it provides a better flexibility for me. I can make sure other user's will not have issues using my computer and at the same time I can have the text spreadsheet in one additional mouse click. Thank you. –  Eugene Dec 21 '09 at 18:55
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.