Greetings
I cannot find a Function in EXCEL to carry out a specific required task and if there isn't one I'm surprised it hasn't been supplied as standard.
I have a spreadsheet in which one of the columns contains cells that have been formatted differently, for example some are 'text', some are 'general' and some are 'numeric' (with different numbers of decimal places).
Incidentally the data represents version numbers of various software programs but the originator of the spreadsheet was inconsistent with the data entry (it should all have been entered as text).
I need a Function to convert each of the displayed (ie formatted not internally stored) cell values to a text string (to produce an adjacent column of displayed values using copy/paste).
If, as I suspect, this involves VBA then I confess I am lost for a start so go easy on me in words of one syllable!
If it is possible to create such a Function, is it feasible for my version of EXCEL (2007) to be customised to include it with all the other Functions for future use as I think it will prove to be very useful?
Many thanks
BazLondon
I cannot find a Function in EXCEL to carry out a specific required task and if there isn't one I'm surprised it hasn't been supplied as standard.
I have a spreadsheet in which one of the columns contains cells that have been formatted differently, for example some are 'text', some are 'general' and some are 'numeric' (with different numbers of decimal places).
Incidentally the data represents version numbers of various software programs but the originator of the spreadsheet was inconsistent with the data entry (it should all have been entered as text).
I need a Function to convert each of the displayed (ie formatted not internally stored) cell values to a text string (to produce an adjacent column of displayed values using copy/paste).
If, as I suspect, this involves VBA then I confess I am lost for a start so go easy on me in words of one syllable!
If it is possible to create such a Function, is it feasible for my version of EXCEL (2007) to be customised to include it with all the other Functions for future use as I think it will prove to be very useful?
Many thanks
BazLondon