Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 01-30-2020, 09:27 AM
BobBridges's Avatar
BobBridges BobBridges is offline Leading zero in field Windows 7 64bit Leading zero in field Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Yeah, but that has to happen when his customer opens the workbook. The OP is looking for something he can put in that cell that'll handle the problem automatically, without the recipient having to do anything special.

I've never done this, but in at least the more recent versions of Excel I've seen an option that defines whether cell values in .csv files are store with quotes always, sometimes or never. I wonder whether setting that to Always (at your end) would result in the value "03" with quotes, and whether it would then read in as you want it at the other end?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
alt + xxxx does not work in Onenote. The leading two bytes are ignored. garyp OneNote 0 07-11-2018 07:10 AM
Leading zero in field How to remove trailing & leading spaces in a cell? LearnerExcel Excel Programming 8 02-04-2018 08:22 PM
Get rid of leading spaces before paragraphs fig000 Word 11 03-14-2016 01:59 PM
Numbering with fixed length having leading 0 pmahesha Word 2 04-15-2015 11:48 PM
Change the leading of a character style??? Char t Word 1 11-05-2011 01:18 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft