CODEWITHSUNDEEP
excelvba
wayne-h
wayne-h

Reputation: 13

excel error checking flags cell as number formatted as text

I have a cell in an excel sheet that has the triangular error flag which displays "the number in this cell is formatted as text or preceded by an apostrophe". That is not the case, all the characters are numeric and the cell format is number. Is there another condition under which this will happen?

I ask because it is creating a problem when accessing the excel file as a database table with another application.

Upvotes: 1

Views: 4453

Answers (2)

user4039065
user4039065

Reputation:

Run Data ► Text to Columns ► Fixed Width ► Finish and you can convert an entire column of imported pseudo-numbers from text that look like number to actual numbers.

Upvotes: 1

MikeG
MikeG

Reputation: 545

Click on the warning icon and choose "Convert to Number". This issue happened because the values were originally supplied when the cells were once formatted as text.

Upvotes: 1

Related Questions