Excel inserts a code when you set a date or time. If you understand it, then you can modify it for your own needs.
For example, Excel does not have a code for the Israeli format of date displays (dd.mm.yy). However, you can create it yourself, by adjusting those codes, after which your spreadsheet will display the date in the Israeli format.
However, no matter which format you use, data should be entered in the top line of the spreadsheet using Excel's standard American format. Don't worry - it will be displayed in the data section of the sheet with the format that you specified.
Zero (0) represents a numerical digit. If there is no digit in that place, then Excel automatically inserts a zero.
The hash or pound mark (#) represents a digit that will not be filled in if it is not required (such as a single-digit date in a month).
In time notation, H is hours, M is minutes, and S is seconds.
In date notations, Y is years, M is months, and D is days.
You might think that would create a problem, but Excel can distinguish between the M for months and the M for minutes, based on the context.
Find out about the Spreadsheet forum
More about spreadsheets
Find out about Jewish and Hebrew forums
Are you required to read this article for a course? Do NOT print out the article. It is copyrighted.
Your exercise for this article is as follows:
Copyright © David Grossman. World rights reserved. This article may not be printed, forwarded, reproduced, or copied in any way or in any medium without written permission from David Grossman.
