date detected as text

[zoharb]

Respected ,
date/timw entered using ctrl+: and ctrl+shift+: is detected as text if space is not kept between two(this creates many problem in further calculations. Do you have the solution PLEASE
Zohar Batterywala

 

[Scott Huish]

Just do a custom format of your time as h:mmAM/PM and leave the value in the cell as is
Not sure what you mean as a space in the date??

 

[popipipo]

First type
=NOW()
And then copy-paste-value

 

[zoharb]

Just do a custom format of your time as h:mmAM/PM and leave the value in the cell as is
Not sure what you mean as a space in the date??

Respected sir
if I simply do ctrl+:ctrl+shift+:
this is detected as text and formulas of date do not work

if I do ctrl+:<make one space>ctrl+shift+:
then it is considered as date and further formulas work
Zohar BAtterywala

 

[Skyybot]

Sounds like you're moving cell data formatted as date to cell with format as text when you add a cell with Ctl+

 

[Scott Huish]

Yeah, it has to match a format that Excel recognizes as a date/time

 

[Scott Huish]

If you're just trying to save keystrokes, make a quick macro like this, and I assign the shortcut key you want.

Sub DateTime()
ActiveCell = Now()
End Sub