#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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.
|
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 |
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 |