Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Changing a cell to a number

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Changing a cell to a number

Resolved · Medium Priority · Version 2007

Reply Thu 19 Jan 2012, 10:14Delegate Gavin said...

Gavin has attended:
Excel Introduction course
Excel Intermediate course

Changing a cell to a number

Hi,

I had a spreadsheet that had a column for business phone numbers. Previously so I could read each number I entered them with spaces so 0207 289 xxxx

On Monday's introduction we were told to change the cell to a number. I have done this but when I made it 0207289xxxx it changed it to 0207289xxxx.00

What have I done wrong?

Many thanks
Gavin

For upcoming training course dates see: Pricing & availability

Reply Thu 19 Jan 2012, 12:19Trainer Paul said...

RE: changing a cell to a number

Hi Gavin, I would suggest using the text option not the number option. You only use the number option if you are going to use the data in a calculation, and a phone number wont be used in a calculation. The reason you are getting the .00 at the end is because you have 2 decimal places included. On your home tab you can removed these using the "decrease decimal command", but as I say, just change it to text and that will fix it.

Reply Thu 19 Jan 2012, 13:12Delegate Gavin said...

RE: changing a cell to a number

Thanks Paul that worked. Now there is the error triangle. Instead of ignoring it for each one, how do I ignore all?

Reply Fri 20 Jan 2012, 10:37Trainer Paul said...

RE: changing a cell to a number

Hi, can you either send me the workbook to paul or explain the error triangle a bit more.

cheers

Excel articles

· What's mine is yours: Sharing data in Excel
· Benefits of learning about Excel charts
· Excel Macros for the Non-Programmer
· Correcting Numerical Glitches In Excel
· How Sharing Your Excel Data Can Help Your Business Flourish

Please browse our web site to find out more about
ms excel courses and other Microsoft training courses.

Excel tip:

Hide columns in an Excel 2010 Worksheet

If you don’t want part of the Excel worksheet to be visible or when you don’t want certain data to appear in print outs, then a simple solution is to temporarily hide a column or multiple columns.

Hiding a single column:

1)Right click on the column header of the column you want to hide (this is the grey bar along the top edge of the worksheet)
2)Choose Hide from the menu
3)This column will now be hidden from view

Hide more than one column:

1)In the column header drag select to highlight the columns you want hidden
2)Right click and choose Hide from the menu

View all Excel hints and tips