Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-23-2021, 10:22 PM
SoMany SoMany is offline Always convert text to number? Windows 7 64bit Always convert text to number? Office 2016
Advanced Beginner
Always convert text to number?
 
Join Date: Oct 2016
Posts: 51
SoMany is on a distinguished road
Default Always convert text to number?

Before I go down the VBA rabbit hole, is there any way to get an entire sheet to always convert text to number?




I have a macro that copies a sheet onto the file I use. The data is always listed as text. This makes using formulas to interpret that text impossible. Before I start playing with my code, I want to know if I can make a sheet automatically convert to number? For an example of the type of macro I'm using, it can be found here.


Edit; I'm aware of a list of ways to manually do it, but I don't want manual, I want automatic. The formula =Value(B1:B100) showed a value of 2 when it was a value of 156. Even if there's no way to get the sheet to always convert to number, I'd be happy with a formula that interprets the data just the same.
Reply With Quote
  #2  
Old 04-26-2021, 02:09 AM
p45cal's Avatar
p45cal p45cal is offline Always convert text to number? Windows 10 Always convert text to number? Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Could you attach an example of a workbook you're copying FROM, and a workbook which has the sheet you're copying to. Normally, numbers would be copied as numbers, so I'll be looking for why this is copying as text.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert text to phone number in merge ChrisComp Mail Merge 1 03-03-2020 10:39 AM
Reliable way to convert text to number with a formula levraininjaneer Excel 8 12-22-2019 04:47 PM
Attendance table Text Value Convert to Number NickFazer Excel 2 11-08-2018 01:29 AM
Always convert text to number? Cannot Convert Text Cell to number format to be able to sort the data jyfuller Excel 10 06-19-2013 05:31 PM
Convert Number to Text devcon Word 0 07-10-2010 01:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:58 PM.


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