Thread: [Solved] Changing a spreadsheet from # stored as text to stored as #?
View Single Post
 
Old 02-08-2017, 11:40 PM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
No, it is not about formatting. It is about the fact that something which appears as numbers actually is text.
Try (for example in G6) to enter the formula: =ISNUMBER(D6) and i H6 the formula: =ISTEXT(D6). The first formula should show TRUE and the second FALSE. To convert all these 'text numbers' to actual numbers I multiplied by 1. Another way (just one cell at a time) is to select D6, press F2 and then press Enter.

I am not sure how this has come, but sometime it happens when importing data from other systems.
Reply With Quote