Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
use the @ sign
i have one cell a1 that has this in it
Tuesday, November 06, 2007 ii the next b1 i would like to put @7:30pm but i keep getting error |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
use the @ sign
@ is the way Lotus indicated a function. You can enter
@SUM(A10:A100) in a cell and XL will convert it to =SUM(A10:A100) To start your cell with @, prefix it with an apostrophe - the apostrophe indicates Text, and won't be displayed. In article , joen wrote: i have one cell a1 that has this in it Tuesday, November 06, 2007 ii the next b1 i would like to put @7:30pm but i keep getting error |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i change dollar sign to rupee sign in sales invoice | Excel Discussion (Misc queries) | |||
Why a plus sign after the equal sign? | Excel Discussion (Misc queries) | |||
can I change the $ sign to a £ sign in an MS template? | Excel Worksheet Functions | |||
XL invoice replace the dollar sign with euro sign | New Users to Excel | |||
-ve no with -1; positive with sign+ and 0 no sign? Tks. | Excel Worksheet Functions |