Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to catch a value in the format like "0E085"
Hi list,
User has a process that export data from PeopleSoft to an Excel file, then upload the Excel file to another system. from the original data, there is one column named as "Dept" and there is one dept named as "0E085". User has no control with the process from PeopleSoft to Excel. but when user looks at the Excel file, the data "0E085" is showing as a value "0" in the Excel file. are there any ways to make this correct? showing "0E085" in stead of "0"? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) | |||
Changing format of column from "general" to "currency" | Excel Programming | |||
Convert "Month" to "MonthName" format from db to PivotTable | Excel Programming |