Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
excel microsoft training - excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel microsoft training - Excel

excel microsoft training - Excel

ResolvedVersion Standard

Simon has attended:
Excel Intermediate course

Excel

how can you include a zero in a cell!

RE: Format Decimals with extra zeros

Hi Simon,

Thanks for your question.

To increase the number of zeros after the decimal point, you simply select FORMAT CELLS -> NUMBER -> increase the decimal places -> press OK

Hope this helps.

Regards,

Katie

Excel tip:

Saving your Excel Spreadsheet as a CSV File

In situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps.

Click the File tab and click Save As.
Enter a name in the File name field.
Click the drop-down arrow next to the Save as type field to select the file type. Scroll down the list and select CSV (comma delimited) (*.CSV)
Click Save

The data will now be saved to a separate CSV file which can be used in different applications.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.08 secs.