Using a = sign
I need to use an equal sign as a constant and get an #Value error. I have
preceeded the equal sign with a single quote ' and surrounded it with double quotes but still get the error. Any ideas??? |
Like in a cell by itself.
Either preformat the cell as text, then type: = or type: '= (notice the leading apostrophe. It forces excel to treat the entry as text.) Dean wrote: I need to use an equal sign as a constant and get an #Value error. I have preceeded the equal sign with a single quote ' and surrounded it with double quotes but still get the error. Any ideas??? -- Dave Peterson |
Maybe try a leading SPACE before the equal sign...........
Vaya con Dios, Chuck, CABGx3 "Dean" wrote in message ... I need to use an equal sign as a constant and get an #Value error. I have preceeded the equal sign with a single quote ' and surrounded it with double quotes but still get the error. Any ideas??? |
All times are GMT +1. The time now is 03:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com