R
Richard RE
Hi,
We have problem with a spreadsheet where we use VBA
(cell, text and csn command) to move inputed data in cells within a column to
a row. The inputed data looks like, 0,3446325533953 and
0,45324657652432 etc, when moved to the assigned row it only have 3
decimals and in this case the above figures will show 0,345 and 0,453. For
the most of the time this function works all right in the spreadsheet
template, but sometimes the format of the cells changes. It converts to hash
symbols (#####), and when moving
the cursor to the cell it instead of saying 0,345 (as for the example above)
it says 3446325533953,000. It looks like delimeter problem bug for me. When
we run "detect and repair" excel solves the wrong output. But since "detect
and repair" takes long time to run we can't live with this in a production
manner.
We are are running an english version of office 2003 pro with sp2 on a
windows xp pro sp2 computer.
We look forward for any hints and proposals of solution.
Thanks,
//Richard
We have problem with a spreadsheet where we use VBA
(cell, text and csn command) to move inputed data in cells within a column to
a row. The inputed data looks like, 0,3446325533953 and
0,45324657652432 etc, when moved to the assigned row it only have 3
decimals and in this case the above figures will show 0,345 and 0,453. For
the most of the time this function works all right in the spreadsheet
template, but sometimes the format of the cells changes. It converts to hash
symbols (#####), and when moving
the cursor to the cell it instead of saying 0,345 (as for the example above)
it says 3446325533953,000. It looks like delimeter problem bug for me. When
we run "detect and repair" excel solves the wrong output. But since "detect
and repair" takes long time to run we can't live with this in a production
manner.
We are are running an english version of office 2003 pro with sp2 on a
windows xp pro sp2 computer.
We look forward for any hints and proposals of solution.
Thanks,
//Richard