Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
auto formating imported numbers
this is kinda novice question,
i am exported a file from UNIX in text format. bascially i have figured out how to import and make the columns in excel. it looks somthing like this:- 2.A) BALANCES WITH BANKS L.C. 21716183 B) BALANCES WITH BANKS F.C. 206691078 C) BALANCESWITH BRANCHES F.C 261096259 i need imported number in number columns to automatically change from e.g. 2176183 to 21,761.83 please bear in mind that the last 2 digits are 2 decimal pnts. i want to somehow convert the whole columns into above mentioned format i.e last 2 number in devimal pnts so that my other workbook can automatically pick up the data from respective feilds. your help is most appreciated |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
auto formating imported numbers
All you have to do is divide your number by 100 and change the format for
number. It will do the trick. -- Yanick "mika" wrote: this is kinda novice question, i am exported a file from UNIX in text format. bascially i have figured out how to import and make the columns in excel. it looks somthing like this:- 2.A) BALANCES WITH BANKS L.C. 21716183 B) BALANCES WITH BANKS F.C. 206691078 C) BALANCESWITH BRANCHES F.C 261096259 i need imported number in number columns to automatically change from e.g. 2176183 to 21,761.83 please bear in mind that the last 2 digits are 2 decimal pnts. i want to somehow convert the whole columns into above mentioned format i.e last 2 number in devimal pnts so that my other workbook can automatically pick up the data from respective feilds. your help is most appreciated |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
auto formating imported numbers
Put 100 in an empty cell
edit|copy Select the range of numbers to reverse Edit|paste special|check Divide and values. Clear that cell with the 100 in it. mika wrote: this is kinda novice question, i am exported a file from UNIX in text format. bascially i have figured out how to import and make the columns in excel. it looks somthing like this:- 2.A) BALANCES WITH BANKS L.C. 21716183 B) BALANCES WITH BANKS F.C. 206691078 C) BALANCESWITH BRANCHES F.C 261096259 i need imported number in number columns to automatically change from e.g. 2176183 to 21,761.83 please bear in mind that the last 2 digits are 2 decimal pnts. i want to somehow convert the whole columns into above mentioned format i.e last 2 number in devimal pnts so that my other workbook can automatically pick up the data from respective feilds. your help is most appreciated -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to extract numbers from imported cell with text and numbers? | Excel Discussion (Misc queries) | |||
How can I eliminate the auto refresh chart when data is imported? | Excel Discussion (Misc queries) | |||
Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
Sorting imported "numbers" | Excel Discussion (Misc queries) |