[Ridemonkey]

How do I escape characters in Excel? I am trying to enter a value that starts with @ - and it tells me "invalid function"

 

[I Are Baboon]

Try an old school trick and enter a ' first. Or right click on the cell, choose Format Cells, Number, Text.

Hope that works, yo.

 

[Ridemonkey]

Cool thanks, the ' worked.

 

[bomberz1qr20]

Originally posted by Ridemonkey
Cool thanks, the ' worked.

Same thing when you want to enter a string of numbers begining with a 0, (example: 0007850, excel will default to 7850)

 

[johnbryanpeters]

Originally posted by bomberz1qr20
Same thing when you want to enter a string of numbers begining with a 0, (example: 0007850, excel will default to 7850)

From da menu,
Format | Cells | Custom | 0000000