ExcelBanter - use the @ sign

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - use the @ sign (https://www.excelbanter.com/new-users-excel/165070-use-%40-sign.html)

joen

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

JE McGimpsey

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

All times are GMT +1. The time now is 11:46 AM.