Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell format changes when a saved sheet is opened on another machine
Hi All,
I created a sheet programatically with cell format as Number and negative numbers to be displayed in red and brackets. This works fine on my machine. However, when the sheet is opened on another machine, negative numbers are not displayed in the required format. The version of excel on the other machine is exactly the same as on my machine. Any clue to why this happens ? is there any setting that we have to change/set programatically so that the format of the excel sheet remains universal ? Thanks, Mandar. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell format changes when a saved sheet is opened on another machine
Further more, i realize that only the format of "calculated" cells
changes. negative numbers in cells for which values are just written into (not calculated) are displayed correctly in brackets. Thus, format for only the calculated cells changes. Mandar. amazingm wrote: Hi All, I created a sheet programatically with cell format as Number and negative numbers to be displayed in red and brackets. This works fine on my machine. However, when the sheet is opened on another machine, negative numbers are not displayed in the required format. The version of excel on the other machine is exactly the same as on my machine. Any clue to why this happens ? is there any setting that we have to change/set programatically so that the format of the excel sheet remains universal ? Thanks, Mandar. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting not saved when file re-opened | Excel Discussion (Misc queries) | |||
Saved Changes Gone Next Time Document is Opened | Excel Discussion (Misc queries) | |||
Running code before any file is opened/saved | Excel Programming | |||
Can a workbook be opened w/out Excel on the host machine?? | Excel Discussion (Misc queries) | |||
Help: I need a sheet to be opened based on a cell value | Excel Programming |