Thanks.
Excel Function
Started by
Leparagon
, May 11 2005 02:31 PM
#1
Posted 11 May 2005 - 02:31 PM
Thanks.
#2
Posted 12 May 2005 - 07:11 PM
Hi, if you want to convert from a date format to number....right click the cell you want the number in, select 'Format cells'...under category: select 'number' and then select 'decimal places=0' since you are working with whole days. You can also format cells by using the 'Format' drop down at the top of the spread sheet and selecting 'cells'
hope this answers your question??!!
J.
if all else fails you can do a paste special, but that can be a little messy.
hope this answers your question??!!
J.
if all else fails you can do a paste special, but that can be a little messy.
Similar Topics
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users