Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cells in web query (leading zeroes)
I am trying to import an aspx page that uses a gridview control to display
data. User needs it in Excel. I do a web query and it works out, but Excel cuts off the leading zeroes in the phone field, which is a text field in the underlying table. I played with all the options, preserve formatting (or not), no formatting, etc. Excel keeps changes to general and therefore deletes the leading zeroes. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cells in web query (leading zeroes)
Try formatting your phone field column as text before you import.
"Kathy" wrote in message ... I am trying to import an aspx page that uses a gridview control to display data. User needs it in Excel. I do a web query and it works out, but Excel cuts off the leading zeroes in the phone field, which is a text field in the underlying table. I played with all the options, preserve formatting (or not), no formatting, etc. Excel keeps changes to general and therefore deletes the leading zeroes. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cells in web query (leading zeroes)
Hi Kathy,
Do you have a fixed number of digits in your phone field? If so you could create a custom format. eg. if you setup a custom format of "000000" (without the talking marks) your numbers will all display as a six digit number. So even better for you would be something like this: "00 0000 0000" which would make our (aussie) phone numbers appear as "03 9350 3456". Hope this helps, Helen "Kathy" wrote: I am trying to import an aspx page that uses a gridview control to display data. User needs it in Excel. I do a web query and it works out, but Excel cuts off the leading zeroes in the phone field, which is a text field in the underlying table. I played with all the options, preserve formatting (or not), no formatting, etc. Excel keeps changes to general and therefore deletes the leading zeroes. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cells in web query (leading zeroes)
Phone field is text. Looks fine on the web page. Only when bringing it into
Excel does it switch. "Wondering" wrote: Try formatting your phone field column as text before you import. "Kathy" wrote in message ... I am trying to import an aspx page that uses a gridview control to display data. User needs it in Excel. I do a web query and it works out, but Excel cuts off the leading zeroes in the phone field, which is a text field in the underlying table. I played with all the options, preserve formatting (or not), no formatting, etc. Excel keeps changes to general and therefore deletes the leading zeroes. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cells in web query (leading zeroes)
Unfortunately, it's a 4-digit dial code. Sometimes it happens to have a
leading zero (0193) and sometimes not (8502). Thanks for the suggestion tho. "IndianSummer" wrote: Hi Kathy, Do you have a fixed number of digits in your phone field? If so you could create a custom format. eg. if you setup a custom format of "000000" (without the talking marks) your numbers will all display as a six digit number. So even better for you would be something like this: "00 0000 0000" which would make our (aussie) phone numbers appear as "03 9350 3456". Hope this helps, Helen "Kathy" wrote: I am trying to import an aspx page that uses a gridview control to display data. User needs it in Excel. I do a web query and it works out, but Excel cuts off the leading zeroes in the phone field, which is a text field in the underlying table. I played with all the options, preserve formatting (or not), no formatting, etc. Excel keeps changes to general and therefore deletes the leading zeroes. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cells in web query (leading zeroes)
You're welcome :-) But..I realise I'm not clear now on your issue - "0000" as
a custom format will cause 193 to display as 0193 and 8502 to display as 8502. Is that not what you wanted? "Kathy" wrote: Unfortunately, it's a 4-digit dial code. Sometimes it happens to have a leading zero (0193) and sometimes not (8502). Thanks for the suggestion tho. "IndianSummer" wrote: Hi Kathy, Do you have a fixed number of digits in your phone field? If so you could create a custom format. eg. if you setup a custom format of "000000" (without the talking marks) your numbers will all display as a six digit number. So even better for you would be something like this: "00 0000 0000" which would make our (aussie) phone numbers appear as "03 9350 3456". Hope this helps, Helen "Kathy" wrote: I am trying to import an aspx page that uses a gridview control to display data. User needs it in Excel. I do a web query and it works out, but Excel cuts off the leading zeroes in the phone field, which is a text field in the underlying table. I played with all the options, preserve formatting (or not), no formatting, etc. Excel keeps changes to general and therefore deletes the leading zeroes. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorry, leading zeroes again :-(( | Excel Discussion (Misc queries) | |||
Leading Zeroes | Excel Discussion (Misc queries) | |||
how to keep leading zeroes when saving in xls in csv format | Excel Discussion (Misc queries) | |||
CSV leading zeroes | Excel Discussion (Misc queries) | |||
How do I format data cells in Excel to keep leading zeroes? | Setting up and Configuration of Excel |