Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Changing a spreadsheet from # stored as text to stored as #? Changing a spreadsheet from # stored as text to stored as #?
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 02-08-2017, 11:40 PM
xor xor is offline Changing a spreadsheet from # stored as text to stored as #? Windows 10 Changing a spreadsheet from # stored as text to stored as #? Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,103
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
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing a spreadsheet from # stored as text to stored as #? location of where fonts are stored? aaronep Word 3 10-10-2013 08:22 AM
Changing a spreadsheet from # stored as text to stored as #? Printer parameters stored where? Doc_man Office 2 06-20-2011 12:27 PM
outlook 2003 - where are rules stored? Newmarket2 Outlook 1 02-13-2011 07:05 AM
Changing a spreadsheet from # stored as text to stored as #? Anyone know where Outlook would have stored sent emails? causton81 Outlook 2 01-27-2011 12:46 PM
Changing a spreadsheet from # stored as text to stored as #? Open .pst file that is stored online vincet2011 Outlook 2 01-14-2011 01:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:08 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft