I have needed to accomplish a similar process in Excel on Windows in the past, but I have never seen such an error before.ġ) Can you please fix this error from occuring?Ģ) Is there a way to write a VBA macro for Excel for Mac that would automate this process (maybe by turning on the ignore error option - from within the macro). 320 total cells selected / 10 cells per error session = 32 times the user must repeat steps 2-5 in order to convert all text cells to numbers) This is all normal/expected behavior.ġ) After selecting an entire field (column) and selecting the 'Convert to Text' option, excel just freezes.Ģ) Upon clicking the screen (anywhere within the active excel window) an Error appears.ģ) The Error is 'Circular Reference Error'Ĥ) Upon clicking 'OK', the error window disappears, and approximately ~ 10 of the selected cells are converted to number successfully.ĥ) The user must repeat steps 2-5 however many times it takes to convert all text cells to numbers (i.e. Where Excel believes these numbers should be 'Converted to Number'. There will be a 'Green Error Flag' in the top left hand corner of a cell You will often see that all fields (columns) have been imported as 'Text'. SalesForce) and then open that file in Excel.
