spreadsheet dropping leading zeroes when exporting from SQL Serve.

RPurgahn

Posts: n/a

spreadsheet dropping leading zeroes when exporting from SQL Serve.

How do you stop Excel from dropping leading zeroes when I import data into it
from an Access application connected to a datatable on a SQL Server?

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
No decimals and leading zeroes	gcotterl	Excel Discussion (Misc queries)	2	April 18th 05 06:50 AM
Displaying leading zeros in an Excel spreadsheet	marianthelibrarian	Excel Discussion (Misc queries)	1	January 25th 05 02:08 PM
CSV leading zeroes	Tim_nol	Excel Discussion (Misc queries)	2	December 28th 04 08:19 PM
How do I format data cells in Excel to keep leading zeroes?	LennyD	Setting up and Configuration of Excel	2	December 15th 04 10:42 PM
single quote 10-digit number that has leading zeroes & then conca.	lorelei739	Excel Worksheet Functions	1	November 5th 04 12:02 AM

All times are GMT +1. The time now is 01:34 PM.

About Us