Text

%3CLINGO-SUB%20id%3D%22lingo-sub-3122604%22%20slang%3D%22en-US%22%3EText%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3122604%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20in%20need%20of%20assistance%20in%20removing%20TEXT%20on%20a%20spreadsheet.%20I%20have%20a%20credit%20card%20report%20which%20was%20downloaded%20from%20the%20bank%20%2C%20however%2C%20the%20numbers%20are%20in%20text%20format.%20I%20made%20several%20attempts%20to%20change%20from%20text%20to%20accounting%20or%20currency%20without%20any%20success.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20a%20few%20things%20nothing%20works%20it%20appears%20that%20the%20entire%20sheet%20in%20in%20text%20format.%20In%20each%20row%20in%20this%20column%2C%20the%20message%20is%20%22the%20number%20in%20this%20cell%20is%20formatted%20as%20text%20by%20an%20apostrophe%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecan%20you%20some%20assist%20me%20with%20this%20matter%20it%20is%20important.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3122604%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I am in need of assistance in removing TEXT on a spreadsheet. I have a credit card report which was downloaded from the bank , however, the numbers are in text format. I made several attempts to change from text to accounting or currency without any success.

 

 

I have tried a few things nothing works it appears that the entire sheet in in text format. In each row in this column, the message is "the number in this cell is formatted as text by an apostrophe"

 

can you some assist me with this matter it is important.

1 Reply

@Patrick2762 

Try selecting a column.

Set the number format to General or to Currency, as appropriate.

On the Data tab of the ribbon, click Text to Columns, then click Finish.

If that helps, repeat for other columns.