see if it help
On Sat, Apr 16, 2011 at 4:55 PM, Dick bobde...@yahoo.com wrote:
I have a text box with the following code. But I'm finding it
difficult for some people to input the correct time by following the
format. Is it possible to have the text box with 3 different entries
such as 0/0/0
Sir,
I have 12 picture embedded in Sheet 1 and i intend to create a hyper link in
Sheet 2 for each picture. Is it possible to do without Macro run.
Referencing to nearby cell is not worthy.
Regards,
C.G.Kumar
--
try this
=SUBSTITUTE(B3,.,-)-SUBSTITUTE(A3,.,-)
On Sun, Apr 17, 2011 at 5:41 PM, Mohd Sanusi Mohd Noor
sanus...@gmail.comwrote:
Dear all,
Would like to seek your kind assistance/help on the date format.
I've a data on date derive from SAP, when transfer to excel the date is in
text
That solution, although not entirely wrong, would not work on all
computers.
This is mainly caused because there are many potential problems :
1) the date items separator (here .)
2) the date structure of the text field (here it is ddmm)
3) the date structure as used by your system (could be