| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=Now()
I have entered this formula into a cell formatted as General. It will not
show the date/time. It is showing the text of the formula. Please help! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=Now()
Is the cell formated to display text? or General? -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=551601 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=Now()
Did you re-enter the formula after changing the format to General? Text
values remain as text until re-entered even if the Cell Format changes. If that doesn't solve the problem, does the formula work in other cells on the same sheet? Do other formulas work in that cell? HTH, Elkar "Karen" wrote: I have entered this formula into a cell formatted as General. It will not show the date/time. It is showing the text of the formula. Please help! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=Now()
The cell was General when I entered the formula. The formula does NOT work
in other cells on the worksheet. "Elkar" wrote: Did you re-enter the formula after changing the format to General? Text values remain as text until re-entered even if the Cell Format changes. If that doesn't solve the problem, does the formula work in other cells on the same sheet? Do other formulas work in that cell? HTH, Elkar "Karen" wrote: I have entered this formula into a cell formatted as General. It will not show the date/time. It is showing the text of the formula. Please help! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=Now()
Tools Options View tab uncheck Formulas
-- Carlos "Karen" wrote in message ... I have entered this formula into a cell formatted as General. It will not show the date/time. It is showing the text of the formula. Please help! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=Now()
Does the formula work in other workbooks?
Do other formulas work in your workbook? Try =1+1. Does it display 2? What about the =TODAY() function? Does that work? If you press Ctrl+; does the current date appear? Are there any Macros or VB Code in your workbook? There may be some code preventing the formula from displaying? Check your AutoCorrect Options. Make sure that =now() didn't somehow end up on the "Replace text as you type" list. I'm running out of ideas here. Perhaps the answers to the above questions can point us in the right direction? "Karen" wrote: The cell was General when I entered the formula. The formula does NOT work in other cells on the worksheet. "Elkar" wrote: Did you re-enter the formula after changing the format to General? Text values remain as text until re-entered even if the Cell Format changes. If that doesn't solve the problem, does the formula work in other cells on the same sheet? Do other formulas work in that cell? HTH, Elkar "Karen" wrote: I have entered this formula into a cell formatted as General. It will not show the date/time. It is showing the text of the formula. Please help! |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=Now()
Heh, far too easy. I should have thought of that. I bet that will be solve
the problem. "CarlosAntenna" wrote: Tools Options View tab uncheck Formulas -- Carlos "Karen" wrote in message ... I have entered this formula into a cell formatted as General. It will not show the date/time. It is showing the text of the formula. Please help! |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=Now()
Karen Two possibles here. 1. View Formulas is enabled. Hit CTRL + `(above Tab key) to toggle off/on. 2. The cell(s) was/were pre-formatted as Text. Changing to General is not enough. You must hit F2 then ENTER key. Gord Dibben MS Excel MVP On Tue, 13 Jun 2006 12:27:02 -0700, Karen wrote: The cell was General when I entered the formula. The formula does NOT work in other cells on the worksheet. "Elkar" wrote: Did you re-enter the formula after changing the format to General? Text values remain as text until re-entered even if the Cell Format changes. If that doesn't solve the problem, does the formula work in other cells on the same sheet? Do other formulas work in that cell? HTH, Elkar "Karen" wrote: I have entered this formula into a cell formatted as General. It will not show the date/time. It is showing the text of the formula. Please help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using the =NOW() Function | Excel Discussion (Misc queries) | |||
| Using the =NOW() Function | Excel Worksheet Functions | |||
| =NOW() Time Function. I want this to be live! | Excel Worksheet Functions | |||
| About =now() function | Excel Discussion (Misc queries) | |||
| possible to have =now() at data entry and not update after that? | Excel Worksheet Functions | |||
Linear Mode
