How do I turn off the automatic conversion to dates?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have often copied tabells to Excel which contained spanned values like
"4-8" and such and I have found no way to stop Excel from turning it inot a
date and no way of converting it back without it just returning the value of
the date. Not even preconfigure the page to text work for me.
For that I want to turn off the function of converting to dates all to
gether since i rarely or ever use it but frequently use spanned values and
don't like having to write a citation mark before and after or preformat the
cell.
Hoping for a quick answer...
 
Format the page as text and then 'paste special' as 'values' from wherever your
data is coming from.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which is the best MBOX Converter Tool different formats conversion? 4
Turn off automatic date formatting 4
Turn off automatic date conversion? 2
Turning off Date Conversion in Excel 4
How to Convert EML to PST in 2025? 2
turn off automatic incremementing of numbers when using drag & dr. 3
Turn off automatic date formatting? 3
How to turn off date autocorrection? 2

Back
Top