use the @ sign

J

joen

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
 
J

JE McGimpsey

@ 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
How can the font and size of (all) citation numbers be altered? 1
Change Style to 'Keep with previous' instead of Keep with Next 1
Microsoft 365 Activations, Users or Devices? 0
If, Or, and 5
Convert times to text string 3
You'll need a new app to open this about link 1
Outlook 365 extremely stubborn 0

Top