Home » Questions » Computers [ Ask a new question ]

Open blank Excel spreadsheet with all cells in text format by default

Open blank Excel spreadsheet with all cells in text format by default

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

Asked by: Guest | Views: 64
Total answers/comments: 1
Guest [Entry]

"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"