I want to save my data using this kind of format 01. The problem is
when i open the file back..the zero is missing. I try to save as text
but the same problem happen. Pls advise. Tq.
> I want to save my data using this kind of format 01. The problem is
> when i open the file back..the zero is missing. I try to save as text
> but the same problem happen. Pls advise. Tq.
As far as fixing the 01 issue in Excel, I ran into that problem with
zip codes with a zero in front. Highlight the column in question, or
cell, then right click on a PC...choose Format Cells...then choose
Text--this will allow the cell to look exactly as you typed it no
matter if numbers or letters.
I hope this helps--
Heather Sickels
720-565-8455
Editor, MondoTimes.com
Mondo Code LLC
Boulder, CO
On Thu, Mar 5, 2009 at 7:14 AM, shriop <shr...@hotmail.com> wrote:
> I'm assuming you're working with Excel. The only way to override this
> behavior in Excel is to change a value of 012 to ="012".
> Bruce Dunwiddie
> On Mar 4, 8:52 pm, ladybug <mimienurak...@gmail.com> wrote:
>> Hi,
>> I want to save my data using this kind of format 01. The problem is
>> when i open the file back..the zero is missing. I try to save as text
>> but the same problem happen. Pls advise. Tq.
Heather ...yes..i did that...but when i open it back...the 0 is
missing.
Is it possible to store 012 without putting " in front and at the
back of the value because i need to upload the data to some database.
With " notation in that value it'll coz some troubles.Thanks eneway
guys.
Regards,
ladybug
The problem with " is when i want
On Mar 6, 12:22 am, Mondo Times staff <mondotimes....@gmail.com>
wrote:
> As far as fixing the 01 issue in Excel, I ran into that problem with
> zip codes with a zero in front. Highlight the column in question, or
> cell, then right click on a PC...choose Format Cells...then choose
> Text--this will allow the cell to look exactly as you typed it no
> matter if numbers or letters.
> I hope this helps--
> Heather Sickels
> 720-565-8455
> Editor, MondoTimes.com
> Mondo Code LLC
> Boulder, CO
> On Thu, Mar 5, 2009 at 7:14 AM, shriop <shr...@hotmail.com> wrote:
> > I'm assuming you're working with Excel. The only way to override this
> > behavior in Excel is to change a value of 012 to ="012".
> > Bruce Dunwiddie
> > On Mar 4, 8:52 pm, ladybug <mimienurak...@gmail.com> wrote:
> >> Hi,
> >> I want to save my data using this kind of format 01. The problem is
> >> when i open the file back..the zero is missing. I try to save as text
> >> but the same problem happen. Pls advise. Tq.
No, it's not possible. If you're sending the file into a database then
you just need to not open the file back up. Maybe keep a file of the
values as a spreadsheet xls, and then when you want to do an upload
save a copy as csv and then don't edit it. This will allow you to
maintain a file without having to deal with the zeros.
Bruce Dunwiddie
On Mar 10, 9:26 pm, ladybug <mimienurak...@gmail.com> wrote:
> Heather ...yes..i did that...but when i open it back...the 0 is
> missing.
> Is it possible to store 012 without putting " in front and at the
> back of the value because i need to upload the data to some database.
> With " notation in that value it'll coz some troubles.Thanks eneway
> guys.
> Regards,
> ladybug
> The problem with " is when i want
> On Mar 6, 12:22 am, Mondo Times staff <mondotimes....@gmail.com>
> wrote:
> > As far as fixing the 01 issue in Excel, I ran into that problem with
> > zip codes with a zero in front. Highlight the column in question, or
> > cell, then right click on a PC...choose Format Cells...then choose
> > Text--this will allow the cell to look exactly as you typed it no
> > matter if numbers or letters.
> > I hope this helps--
> > Heather Sickels
> > 720-565-8455
> > Editor, MondoTimes.com
> > Mondo Code LLC
> > Boulder, CO
> > On Thu, Mar 5, 2009 at 7:14 AM, shriop <shr...@hotmail.com> wrote:
> > > I'm assuming you're working with Excel. The only way to override this
> > > behavior in Excel is to change a value of 012 to ="012".
> > > Bruce Dunwiddie
> > > On Mar 4, 8:52 pm, ladybug <mimienurak...@gmail.com> wrote:
> > >> Hi,
> > >> I want to save my data using this kind of format 01. The problem is
> > >> when i open the file back..the zero is missing. I try to save as text
> > >> but the same problem happen. Pls advise. Tq.
|
