How in excel do I format as absolutely text, don not mess with it at all !!
I need my data exactly as I put it in.
one field is:
2011-03-27
even formated as "text" Excell likes to play with it. j
the old trick of putting a single quote in front of it can not work here because I can not
have it here. This feeds a script into another app.
Notepad does it but I want to have mutiple records ( info on servers )
one field is:
2011-03-27
even formated as "text" Excell likes to play with it. j
the old trick of putting a single quote in front of it can not work here because I can not
have it here. This feeds a script into another app.
Notepad does it but I want to have mutiple records ( info on servers )
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
format the cell as a date, and specify that particular format. it's available by default:
Format the cells as text, (right click format | number | text) ... but do it before entering any data!
Chris
Chris
Here is a sample:
Sample.xls
Sample.xls
ASKER
thank you all.
Sorry I think Jimmy had it and others pretty much agreed with his solution.
Thank you all
Sorry I think Jimmy had it and others pretty much agreed with his solution.
Thank you all