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 out how to convert …
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 tools (e.g. …
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 column. Basically, …
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?
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 - aaa; 354 - …
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 to date the …
Convert Text to to Short Date [SOLVED] - Excel Help Forum
Feb 16, 2023 · Convert Text to to Short Date I have a spreadsheet full of long dates formatted as text (i.e. January 1, 2023). I changed the cell format to short date (01/01/2023). But it only converts to the …
"Convert to Number" option disappearing [SOLVED] - Excel Help Forum
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 of data …
[SOLVED] Looking for a formula to convert American ... - Excel Help …
Feb 21, 2017 · Forum Microsoft Office Application Help - Excel Help forum Excel Formulas & Functions [SOLVED] Looking for a formula to convert American dates to British dates. The use of AI tools (e.g. …
[SOLVED] Convert Text :> Time... Using VBA - Excel Help Forum
Apr 6, 2021 · Forum Microsoft Office Application Help - Excel Help forum Excel Programming / VBA / Macros [SOLVED] Convert Text :> Time... Using VBA The use of AI tools (e.g. chatGPT, BARD, …