Convert text to hex [SOLVED] - Excel Help Forum
Dec 1, 2005 · Convert text one of the resultant columns into hex data which can then be converted to decimal - easy NOT ( apparently ) The hex to decimal bit is easy but I can't find …
Convert a formula text to a working formula without vba [SOLVED]
Sep 1, 2023 · Forum Microsoft Office Application Help - Excel Help forum Excel Formulas & Functions [SOLVED] Convert a formula text to a working formula without vba The use of AI …
Converting text based fractions to numerical values [SOLVED]
Aug 28, 2018 · Converting text based fractions to numerical values I have a spreadsheet with text based fraction values. I would like to convert these fractions into decimals in an adjacent …
Convert rows into 1 cell or 1 string - Excel Help Forum
Sep 6, 2005 · If I have a worksheet with 10 rows going down, how can I join all of them into 1 cell. Ex) 123 - aaa; 354 - ghg; 246 - hbf; 234 - ggd; I want the above 4 to fit into one cell like 123 - …
Cells won't convert to number format, even after format/cells/num.
Apr 12, 2005 · In excel, I tried to convert numbers to number format, using format/cells/number from the category list. But it won't take, and stays text-like. Any ideas?
cannot convert text to number? [SOLVED] - Excel Help Forum
Sep 4, 2023 · cannot convert text to number? I have a spreadsheet of data exported from and ACT database - and it has several issues that make it hard/messy. One is that it adds an …
Unable to Convert to Date [SOLVED] - Excel Help Forum
Jan 23, 2025 · Unable to Convert to Date Hi, guys. Pardon my english. I'm trying to convert data in column A to date with format DD/MM/YYYY, but some cells are formatted as text with …
Cannot convert text to date [SOLVED] - Excel Help Forum
Oct 23, 2013 · Cannot convert text to date I have dates in a spreadsheet but some are text and some are number. Simply put, I need them to be all the same, which ever is easier to convert …
"Convert to Number" option disappearing [SOLVED] - Excel Help …
Jun 10, 2005 · Hi Mike, In a helper cell enter the number 1. Copy that cell and then paste special/multiply into the cells you want to convert. HTH ray "Mike" wrote: > When I have a lot …
Convert Text Range in cell to count number of Cells [SOLVED]
Jul 29, 2025 · I have a cell with a rectangular text range written D17:G66. I would like to count the number of cells in this rectangular range. What formula should I use to calculate that number …