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
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.
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?
RE: changing a cell to a number
Hi, can you either send me the workbook to paul@stl-training.co.uk or explain the error triangle a bit more.
cheers
