Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-04-2014, 11:29 AM
gebobs gebobs is offline Copying and pasting acount data into Excel as text will not reformat to a number or currency Windows 7 64bit Copying and pasting acount data into Excel as text will not reformat to a number or currency Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

In cases such as this, all you need to do is go in and retype one of the characters and I think Excel comes out of its coma and knows its a number. Alternatively, you can do a find/replace for some common character, perhaps a decimal or a dollar sign.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying and pasting acount data into Excel as text will not reformat to a number or currency Loop through Word doc to find and reformat text Sandy27 Word VBA 5 01-06-2014 03:48 PM
Copying data from Project to Excel OTPM Project 13 12-20-2013 10:25 AM
copying and pasting Excel tables into Word derohanes Word 1 01-24-2013 12:07 AM
Copying and pasting acount data into Excel as text will not reformat to a number or currency Copying and pasting from Excel Lorna B Word 1 03-20-2012 11:58 PM
Copying and pasting acount data into Excel as text will not reformat to a number or currency Maintain formatting while copying text from word, and pasting into a webpage. kdogg121 Word 1 07-07-2009 02:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:46 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft