Invisible character in the spreadsheet

Laulienin

New Member
Joined
Dec 16, 2013
Messages
4
I have an excel spreadsheet (excel 2010) , There is a column in a sheet that when i type text , the text will be disappeared from the cell, cant see on formulas bar as well. But when I type number, i can see it like normal cell. I thing this column is set some formula to allow only number. Can you advise how to change this column to be a normal column?
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Welcome to MrExcel.

If you right click the cell and choose Format Cells what is in the Type box on the Number tab? This would have the result you are seeing:

General;General;;
 

Laulienin

New Member
Joined
Dec 16, 2013
Messages
4
The cell is set formula and the formula is hidden. Could you please advise how to reveal it. I selected Formulas and click show formulas but the hidden formula still has not been revealed.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,122
Messages
5,466,814
Members
406,500
Latest member
Tknotmaxx

This Week's Hot Topics

Top