Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4,624
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how can i change dollar sign to rupee sign in sales invoice vishal kohli Excel Discussion (Misc queries) 3 May 10th 07 02:06 PM
Why a plus sign after the equal sign? [email protected] Excel Discussion (Misc queries) 3 June 5th 06 06:42 PM
can I change the $ sign to a £ sign in an MS template? tony Excel Worksheet Functions 1 January 2nd 06 07:31 PM
XL invoice replace the dollar sign with euro sign Pamela casares New Users to Excel 2 December 16th 05 09:21 PM
-ve no with -1; positive with sign+ and 0 no sign? Tks. shirley Excel Worksheet Functions 1 November 23rd 05 07:14 AM


All times are GMT +1. The time now is 05:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"