T
timspin
Hi all,
Im trying to use a two digit date in calculations, e.g. 98, 99, 00
01.
Now if I use a text format to get 00 then it doesnt appear as
number.
If I use custom, yy as a format then each time I say type in 00, th
actual cell returns 00/01/1900. If I type in 2000 then I ge
22/06/1905
How can I have 00 in a cell and use it in a calculation as exactl
that, 0
Please help.
All the best
Tim Ge
Im trying to use a two digit date in calculations, e.g. 98, 99, 00
01.
Now if I use a text format to get 00 then it doesnt appear as
number.
If I use custom, yy as a format then each time I say type in 00, th
actual cell returns 00/01/1900. If I type in 2000 then I ge
22/06/1905
How can I have 00 in a cell and use it in a calculation as exactl
that, 0
Please help.
All the best
Tim Ge