custom function to convert numbers stored as text
Josh,
There is no way of knowing what you truly mean because you didn't provide an
example (as was mentioned in a prior post). However, if you have a numeric
value in the spreadsheet and the spreadsheet is treating that numeric value
as text, then here are two built-in Excel ways that should get that text into
a number.
(1) In a separate cell: =NumberTextCell+1-1. Copy (new formula cells)-Paste
Special-Values
(2) Place a 1 somewhere on the spreadsheet. Copy the 1-select numeric cells
that are text-Paste Special-Multiply
Best,
Matthew Herbert
"Josh Craig" wrote:
Hi everyone,
I know you can convert text to numbers with the whole paste multiply by 1
thing but I was wondering if anyone had seen code (or would know what code to
use) to convert numbers stored as text to numbers using a custom built VBA
function?
Any help greatly appreciated!
Josh
|