Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
4 12 28
Impact
~124k people reached

  • 0 posts edited
  • 0 helpful flags
  • 47 votes cast
Sep
17
asked How to determine if a Service account has login as batch rights to a server
Sep
13
accepted Animated GIF of recorded screen activity
Sep
12
asked Animated GIF of recorded screen activity
Sep
4
comment Entering a null value from the keyboard or using menus
CSV fields have the concept of NULL if field delimiters are used and Excel handles CSV files, though poorly. However, the only way that I know to get a null value into the file is using Notepad.
Sep
4
asked Entering a null value from the keyboard or using menus
Aug
30
comment Looking for an explanation of this VLOOKUP function
Ah. I didn't recognize $C$4 as a reference to the C4 column. I expected it to be written simply as C4. Is this an alternate syntax?
Aug
30
asked Looking for an explanation of this VLOOKUP function
Aug
23
asked What is using port 80?
Aug
22
comment Finding the physical local path associated with a Share UNC folder
Thank you !!!!!
Aug
22
accepted Finding the physical local path associated with a Share UNC folder
Aug
22
asked Finding the physical local path associated with a Share UNC folder
Jul
31
awarded  Notable Question
Jun
13
awarded  Popular Question
Jun
3
comment Why is Excel removing leading leading zeros when displaying CSV data?
Yeah, I was already looking for a CSV editor. I saw CSVEd. My initial impression is that it looks like a confusing ametuerish interface. I think "Tabular Text Editor" looks better. Thanks for your help.
Jun
2
accepted Why is Excel removing leading leading zeros when displaying CSV data?
Jun
2
comment Why is Excel removing leading leading zeros when displaying CSV data?
Here's a complication: After importing it as you describe, I then want the ability to modify the file and to save it back as CSV. It presents me with a convoluted ugly dialog box (c'mon microsoft-design a custom dialog form for this instead of using the MessageBox Windows feature!). I choice the option to "keep it in the same format". When I do so, it defaults to a tab separated format. To ensure that the txt file is saved with a comma separator, you have to change the file name extension back to "csv." Is this ugly of what? After 10 versions of Excel we have this?
Jun
2
comment Why is Excel removing leading leading zeros when displaying CSV data?
My issue was that my file had a csv extension and the Import dialog never comes up. when I renamed the file to have a text extension, I was all set and knew where to go. ty.
Jun
2
comment Why is Excel removing leading leading zeros when displaying CSV data?
howtogeek.com/howto/microsoft-office/…
Jun
2
comment Why is Excel removing leading leading zeros when displaying CSV data?
Robert was not my aunt. :-) I thought I had success doing that before, but it didn't work. Try it. What confused me is why formating the cell as text does not result in the value "02" being dispkayed with a leading 0 left justified.
Jun
1
asked Why is Excel removing leading leading zeros when displaying CSV data?