If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Problem with Date
Dear all,
I've a problem with date when I input a cell with text and a date. I input: ="The profit of selling tickets as at" & NOW() Return: =The profit of selling tickets as at 38871.9924.... Please kindly advise how to fix this problem. Thanks. |
#2
|
|||
|
|||
Problem with Date
Denny
Try something like ="The profit of selling tickets as at " & TEXT(NOW (),"dd/mm/yyyy") Tony -----Original Message----- Dear all, I've a problem with date when I input a cell with text and a date. I input: ="The profit of selling tickets as at" & NOW() Return: =The profit of selling tickets as at 38871.9924.... Please kindly advise how to fix this problem. Thanks. . |
Thread Tools | |
Display Modes | |
|
|