The Zero Dilema

Often you want enter a number that begins with a Zero (Invoices, Zip codes). How frustrating it can be when you want the preceding zero(s) to appear in the cell.  In an Excel cell enter 0012345 and press enter.  OOPS! No Zeros! – only 12345 appears.  Go back to the cell and check the edit bar above – no zeros there either – like you never entered them.

STOP the Frustration! Precede 0012345 with an apostrophe usually located to the immediate left of the Enter key on most keyboards.

Now try it again as follows: ‘0012345

Problem solved!

Call Peter at PAS Administrative Support Services

We can Solve your Office Headaches

613-347-9893          pas-admin@sympatico.ca