G Guest May 25, 2007 #1 Whenever I save a file from Excel to a floppy disk it adds "%20" instead of spaces. Is there anyway to keep this from happening? Thanks!
Whenever I save a file from Excel to a floppy disk it adds "%20" instead of spaces. Is there anyway to keep this from happening? Thanks!
P Peo Sjoblom May 25, 2007 #2 Avoid saving files on floppies, sooner or later you will get a corrupt file, save it on the HD, then transfer it to the floppy
Avoid saving files on floppies, sooner or later you will get a corrupt file, save it on the HD, then transfer it to the floppy
D Dave Peterson May 25, 2007 #3 I agree with Peo. But I'm betting that you downloaded a file from the internets. Lots of times, filenames get that %20 stuff instead of spaces. It's got to do with HTML and links and stuff I don't know about.
I agree with Peo. But I'm betting that you downloaded a file from the internets. Lots of times, filenames get that %20 stuff instead of spaces. It's got to do with HTML and links and stuff I don't know about.
P Paddy May 26, 2007 #4 dhughes said: Whenever I save a file from Excel to a floppy disk it adds "%20" instead of spaces. Is there anyway to keep this from happening? Thanks! Click to expand... %20 is a space. 20 decimal is the ASCII code for space; % indicates that the number following defines that character in terms of ASCII code. To stop it from happening, don't use spaces. Use dash or underscore instead. Paddy
dhughes said: Whenever I save a file from Excel to a floppy disk it adds "%20" instead of spaces. Is there anyway to keep this from happening? Thanks! Click to expand... %20 is a space. 20 decimal is the ASCII code for space; % indicates that the number following defines that character in terms of ASCII code. To stop it from happening, don't use spaces. Use dash or underscore instead. Paddy
C Chip Pearson May 27, 2007 #5 %20 is a space. 20 decimal is the ASCII code for space; Close but not quite. The '20' is hex, not decimal, for a space. Decimal is 32. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting LLC www.cpearson.com (email on the web site)
%20 is a space. 20 decimal is the ASCII code for space; Close but not quite. The '20' is hex, not decimal, for a space. Decimal is 32. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting LLC www.cpearson.com (email on the web site)
