Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Text and numbers are shown as General in excel 2010

17 Oct 2014   #1
Franky

windows 7 32-bit
 
 
Text and numbers are shown as General in excel 2010

Hello,

When I enter a text into a cell, say "Programming" or a number, say "12.543", Excel shows each one as general instead of a text or number! Why please?

What text or number I need to enter into a cell that Excel shows and treats it as number or text?


My System SpecsSystem Spec
.
17 Oct 2014   #2
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

To set the actual formatting of each cell you need to select from the General drop down menu.
The screen shot below shows where to find this. There are a lot of options here for cell formatting. This screen shot is from Excel 2013, but I think Excel 2010 is the sane.

Text and numbers are shown as General in excel 2010-excel_cell_formatting_menu.png


My System SpecsSystem Spec
18 Oct 2014   #3
Franky

windows 7 32-bit
 
 

Excuse me! I asked about the way MS Excel itself recognizes the format. I know by using that list how to apply the formats
I say, for example, when I enter "21-3-2014", Excel immediately recognizes it and shows it as date in General menu. What about texts and numbers? That is, for example, what text I need to enter into a cell so that Excel itself immediately (like date) recognizes it and shows it as "text" in General menu?
My System SpecsSystem Spec
.

Reply

 Text and numbers are shown as General in excel 2010




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
How to go back from Excel 2010 64 bit to Excel 2010 32 bit
I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In...
Microsoft Office
A Quick way to paste predetermined text/numbers?
Basically I am looking for any way that will enable me to paste a predetermined string of text or numbers e.g. if i pressed F1 then that will automatically paste "hello" and F2 would paste "My Name is" etc Does anybody know of a way how this could be done? It does even have to be a hotkey, it...
General Discussion
Please Help - Data in Text File to be arranged in Excel in a specific
Hello Everyone, Its my first post here :-) I have a text file with values printed like these; BSSID: 001E4ABXXXX Last seen: 14/12/2011 - 16:06:12 Vendor: Cisco Systems Signal: -91 dBm SSID: NXXXX Enc: OPEN
Microsoft Office
outlook 2010 emails not shown in SENT box
I run an accounting program called PASTEL ACCOUNTING which generates emails that are sent to OUTLOOK 2010's outbox. i can see them in the outbox and they are subsequently sent correctly. i know this because they are received correctly by the recipient. However once the mail has left the Outbox...
Browsers & Mail
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
Excel 2010 not entering previously entered text automatically
Excel 2010. Win 7 ultimate. Excel will duplicate text as I type within the same session that I originally entered the text to the spreadsheet. However, if I close the file and then reopen it it won't automatically enter text as I type of previously entered cells. Can't seem to find option to turn...
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 23:40.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App