Excel text converted to Number or other

J

jonkaleb

when converting from text to number or general how do you
mass update the column instead of double clicking then
<enter>
 
J

Jason Morin

Copy an open cell, select your column, and do Edit > Paste
Special > Add.

HTH
Jason
Atlanta, GA
 

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

Excel does not accept text format! 0
How can the font and size of (all) citation numbers be altered? 1
Autonumber field in Excel that behaves the same as Access 0
Disable Outlook AutoCorrect with GPO 0
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
Paragraph numbering in Word 1
Visio shape text disappears upon copy paste 1
Finding the proper style field and the numbered paragraph value within the style 0

Top