Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am importing a fixed length text file containing numeric data with an
implied decimal point. I want to format the worksheet column to include the decimal point. E.g. text file '000012345', worksheet column '0000123.45' I can format the column as numeric to include the decimal point and divide the value by 100 to get the precision. I am not sure how to define the calculation for the column. I'm assuming that dividing by 100 is the easiest way to do this. Let me know if there is an easier way. Thanks, Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I convert time (38:30) to decimal (38.5) format? | Excel Worksheet Functions | |||
cell custom format | Excel Worksheet Functions | |||
Numbers after decimal point excel to word mail merge | Excel Worksheet Functions | |||
Change decimal format of cells depending on conditions? | Excel Worksheet Functions | |||
decimal point override does not work | Excel Discussion (Misc queries) |