 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / May 2005Identifying numbers formatted as text or apostraphe
Using Excel 2000 ive a spreadsheet with the wrong end total. Looking at it, everything appears ok apart from the end total which is wrong. The cell that the autosum didnt count is not formatted as text or have an apostraphe in front of the number but excel is not counting this number. I opened the spreadsheet in excel 2003 and its the same but Excel 2003 identifies the cell as a problem (green tag put in the corner of the cell) as being formatted as text or has an apostraphe - it is formatted as number and does not have an apostraphe. Excel 2003 repairs it just fine, its just how is it possible to tell on other spreadsheets if this is the case whilst using excel 2000? > Using Excel 2000 ive a spreadsheet with the wrong end total. > [quoted text clipped - 10 lines] > Excel 2003 repairs it just fine, its just how is it possible to tell on > other spreadsheets if this is the case whilst using excel 2000? Ok, sorry - found the reason .... Basically if a number is entered into a cell that is currently formatted as text and then copied elsewhere it is still stored as text, even if the format of the cell is chnaged to number format, you have to re-enter the number in the cell for it change. Hi One solution is to copy a blank unused cell. Select your range of 'numbers' and then Edit|Paste Special|Add. This will make Excel add a zero to each 'number' and make the text entries into numbers. Hope this helps.  SignatureAndy. >> Using Excel 2000 ive a spreadsheet with the wrong end total. >> [quoted text clipped - 17 lines] > the format of the cell is chnaged to number format, you have to re-enter > the number in the cell for it change. > Hi > One solution is to copy a blank unused cell. Select your range of 'numbers' > and then Edit|Paste Special|Add. > This will make Excel add a zero to each 'number' and make the text entries > into numbers. > Hope this helps. Yes, cheers .... I copied them across to the next column using cell * 1 and this worked for the text numbers too. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.