Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell formatting and format conversion
I have a question regarding Excel's interpretation of entered info and how it converts it. Example 1: I type in the following in a cell: 074410E4 Excel displays it as 7.44E+08 Example 2: I type in the following in a cell: 08121126 Excel displays it as 8121016 I tried setting different formatting for the cells and copying around and still cannot get the cell to display exactly how I entered it. Same undesired behavior when copying/pasting with a macro. My goal is to have the data exactly the way I entered it. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel format conversion | New Users to Excel | |||
Time format conversion | Excel Discussion (Misc queries) | |||
date format conversion | Excel Programming | |||
Conversion of date into different format | Excel Discussion (Misc queries) | |||
Date Format - Conversion | Excel Discussion (Misc queries) |