excel
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 2007

replyReply Mon 20 Dec 2010, 16:17Delegate Siobhan said...

Siobhan has attended:
Word Advanced course
Powerpoint Introduction course
Excel Introduction course
Excel Intermediate course

Excel

How do you insert 0 at the start of a number in an Excel worksheet?

For upcoming training course dates see: Pricing & availability

replyReply Mon 20 Dec 2010, 16:37Trainer Nafeesa said...

RE: Excel

Hi Siobhan,


Thank you for your question.

The quickest, easiest way to include the 0 at the start of a string of numbers is to format the cells as text (Format cells - Number tab - Text)


I hope this resolves your question. If it has, please mark this question as resolved.



If you require further assistance, please reply to this post.


Regards,


Nafeesa

Microsoft Office Specialist Trainer

replyReply Mon 20 Dec 2010, 16:38Trainer Nafeesa said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Mon 27 Dec 2010: Automatically marked as resolved.

 

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

Excel tip:

Working with 3D formulas

You can only use fill-down if you remove $ for Absolute References.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard