Saving zero prefix value in CSV
86 views
Skip to first unread message
ladybug
Mar 4, 2009, 9:52:42 PM3/4/09
to CSVChat
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.
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.
shriop
Mar 5, 2009, 9:14:12 AM3/5/09
to CSVChat
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
behavior in Excel is to change a value of 012 to ="012".
Bruce Dunwiddie
Mondo Times staff
Mar 5, 2009, 11:22:40 AM3/5/09
to CSV...@googlegroups.com
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
--
Mondo Times - The worldwide media guide: www.mondotimes.com
Media Owners - Who owns the American media? www.mediaowners.com
Easy Media List - Download media contact lists: www.easymedialist.com
Mondo Stars - Media movers, shakers & newsmakers: www.mondostars.com
Mondo Newspapers - All the newspaper, everywhere: www.mondonewspapers.com
Mondo Code LLC: www.mondocode.com
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
Mondo Times - The worldwide media guide: www.mondotimes.com
Media Owners - Who owns the American media? www.mediaowners.com
Easy Media List - Download media contact lists: www.easymedialist.com
Mondo Stars - Media movers, shakers & newsmakers: www.mondostars.com
Mondo Newspapers - All the newspaper, everywhere: www.mondonewspapers.com
Mondo Code LLC: www.mondocode.com
ladybug
Mar 10, 2009, 10:26:20 PM3/10/09
to CSVChat
Hi,
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:
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:
shriop
Mar 10, 2009, 10:35:43 PM3/10/09
to CSVChat
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
> > Mondo Code LLC:www.mondocode.com- Hide quoted text -
>
> - Show quoted text -
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
>
> - Show quoted text -
Reply all
Reply to author
Forward
0 new messages