१३ नोव्हेंबर, २०१०

Writing date in a cell

Again we are talking about Excel.

Some people want the date to be specifically written in a cell in this order:
Number, word, Number.
For example,
13 November 2010

Select any cell; for example, A2. 
A1 is considered as the cell for column heading. In this case, the heading is 'Date'.

In A2, type date as 13 November 2010
Observe that the date has become 13-Nov-2010.
This means writing 13 November 2010 as it is, is not the proper way.
Delete the matter.
In the same cell, type single inverted comma ( ' )in the cell.
Type 13 November 2010.
Observe that the cell has remain unchanged as 13 November 2010.

कोणत्याही टिप्पण्‍या नाहीत:

टिप्पणी पोस्ट करा