MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Entering Numbers into Cells


Posted by Niv on November 12, 2001 5:33 AM

Am I able to enter a number into a cell that has a space, without the use of ' before the number.
eg. 511 501001 ???


Posted by David Kelly on November 12, 2001 5:56 AM

I am guessing that the entered data is not supposed to be a number. If this is the case why not format the cell as text

Posted by Paul on November 12, 2001 5:57 AM

Format the Cells as text