default all to text only when new sheet/document

[madEG]

Hello,

Q: Is there a way to set the default data types for excel to be text for every column, by default when making new sheet/document?

I get annoyed when (in haste) I paste in data, which excel destroys in it's interest in helping. e.g. Dropping leading zeros on numbers that I want treated as text... Dropping leading zeros on SSNs, or Zip codes...

OMG and don't get me started with invoice numbers that are changed to scientific notation! It makes my blood boil just thinking about how excel wanted to "help me" - ARRRG!

Any tips would be great. Thanks!

 

[noboffinme]

Hi madEG,

One option would be to record a Macro into your Personal workbook that does all the formatting you need & then add a button to run that code to your quick access toolbar.

Then you can open any workbook, worksheet & click the button, run the Macro & there's the formatting done in no time.

First up, record a macro ensuring you save it to your personal workbook by selecting personal workbook in the 'save macro in' dropdown box.

Next follow the instructions on the below link;
http://www.officetooltips.com/excel/tips/create_a_toolbar_button_or_menu_item_to_run_a_macro.html

Hth

 

[madEG]

Thanks! That is a good idea... Then I am only one button push away from no longer pulling my hair out.