SOLVED

Lost Number Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-3366398%22%20slang%3D%22en-US%22%3ELost%20Number%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3366398%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20large%20database%20of%20technical%20information%20that%20I%20have%20accumulated%20since%202005.%26nbsp%3B%20It%20consists%20of%20texts%2C%20simple%20equations%2C%20dates%2C%20IF%20statements%2C%20VLOOKUPs%2C%20etc.%26nbsp%3B%20I%20placed%20the%20file%20in%20Dropbox%20for%20an%20intern%20to%20update%20with%20new%20columns%20and%20entries.%26nbsp%3B%20Student%20is%20now%20gone.%26nbsp%3B%20I%20think%20I%20know%20what%20the%20issue%20is%2C%20but%20I%20don't%20know%20how%20to%20revert%20back%20the%20entire%20worksheet.%26nbsp%3B%20Texts%20remain%20texts%2C%20simple%20equations%2C%20IF%20statements%2C%20VLOOKUPs%20appear%20as%20texts%20and%20dates%20appear%20as%20numbers.%26nbsp%3B%20When%20I%20try%20to%20change%20the%20formatting%20back%20to%20the%20original%2C%20nothing%20changes.%26nbsp%3B%20I've%20attempted%20numerous%20times.%26nbsp%3B%20Would%20the%20intern%20have%20changed%20the%20entire%20%22worksheet%22%20formatting%20so%20as%20I%20cannot%20change%20them%20individually%3F%3F%26nbsp%3B%20Help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3366398%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3367445%22%20slang%3D%22en-US%22%3ERe%3A%20Lost%20Number%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3367445%22%20slang%3D%22en-US%22%3EThank%20you!%20It%20worked.%3CBR%20%2F%3E1.%20It%20is%20*.xlsx%3CBR%20%2F%3E2.%20ctrl%2Bbackquote%20worked%3CBR%20%2F%3E3.%20The%20issue%20I%20believed%20was%20all%20the%20cells%20in%20the%20entire%20worksheet%20was%20%22formatted%22%20to%20text%3B%20NOT%20converted%20to%20text.%20A%20solution....%20I%20did%20not%20have%20till%20now.%20Would%20this%20be%20correct%20understanding%20of%20what%20the%20issue%20could've%20been%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20for%20the%20tip!%20Now%20I%20can%20move%20forward.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3375939%22%20slang%3D%22en-US%22%3ERe%3A%20Lost%20Number%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3375939%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1388654%22%20target%3D%22_blank%22%3E%40GigiB1971%3C%2FA%3E%26nbsp%3B%20wrote%3A%26nbsp%3B%20%60%60Would%20this%20be%20correct%20understanding%20of%20what%20the%20issue%20could've%20been%3F%60%60%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENo.%26nbsp%3B%20It%20is%20not%20a%20formatting%20issue%3B%20at%20least%2C%20not%20in%20the%20normal%20sense%20(cell%20formatting).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EInstead%2C%20the%20ctrl-backquote%20feature%20displays%20all%20formulas%20in%20all%20cells.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhile%20you%20are%20in%20that%20mode%2C%20the%20formulas%20are%20not%20execute.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3367172%22%20slang%3D%22en-US%22%3ERe%3A%20Lost%20Number%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3367172%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1388654%22%20target%3D%22_blank%22%3E%40GigiB1971%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20description%20is%20subject%20to%20interpretation.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%2C%20what%20is%20the%20name%20of%20the%20file%3F%26nbsp%3B%20In%20particular%2C%20does%20it%20end%20with%20%22.txt%22%20or%20%22.csv%22%2C%20or%20does%20it%20end%20with%20%22.xlsx%22%20or%20%22.xlsm%22%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESecond%2C%20if%20it%20is%20an%20XLSX%20or%20XLSM%20file%2C%20try%20pressing%20ctrl%2Bbackquote.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFinally%2C%20if%20you%20think%20you%20%22know%20what%20the%20issue%20is%22%2C%20please%20share%20your%20insights%20with%20us.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20backquote(%20%60%20)%20might%20be%20on%20the%20key%20just%20below%20the%20Esc%20key%2C%20usually%20in%20the%20upperleft%20of%20the%20keyboard.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a large database of technical information that I have accumulated since 2005.  It consists of texts, simple equations, dates, IF statements, VLOOKUPs, etc.  I placed the file in Dropbox for an intern to update with new columns and entries.  Student is now gone.  I think I know what the issue is, but I don't know how to revert back the entire worksheet.  Texts remain texts, simple equations, IF statements, VLOOKUPs appear as texts and dates appear as numbers.  When I try to change the formatting back to the original, nothing changes.  I've attempted numerous times.  Would the intern have changed the entire "worksheet" formatting so as I cannot change them individually??  Help!

3 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@GigiB1971 

 

Your description is subject to interpretation.

 

First, what is the name of the file?  In particular, does it end with ".txt" or ".csv", or does it end with ".xlsx" or ".xlsm"?

 

Second, if it is an XLSX or XLSM file, try pressing ctrl+backquote.

 

Finally, if you think you "know what the issue is", please share your insights with us.

 

The backquote( ` ) might be on the key just below the Esc key, usually in the upperleft of the keyboard.

Thank you! It worked.
1. It is *.xlsx
2. ctrl+backquote worked
3. The issue I believed was all the cells in the entire worksheet was "formatted" to text; NOT converted to text. A solution.... I did not have till now. Would this be correct understanding of what the issue could've been?

Thanks for the tip! Now I can move forward.

@GigiB1971  wrote:  ``Would this be correct understanding of what the issue could've been?``

 

No.  It is not a formatting issue; at least, not in the normal sense (cell formatting).

 

Instead, the ctrl-backquote feature displays all formulas in all cells.

 

While you are in that mode, the formulas are not calculated.