Law

Posts: n/a

I need help insert a decimal other then directly to the right of t

I am importing a text file in to Excel. The data for the amount filed does
not include the decimal place. So I need to insert the decimal into the
number. For example the data is

1234

I want to insert the decimal right in the middle as

12.34

I would greatly appreciate anyones help on this.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
insert picture	BillGwyer	Excel Discussion (Misc queries)	1	March 4th 05 06:37 PM
How do I override fixed decimal place settings in EXcel 2003?	jroyv	Excel Worksheet Functions	2	February 11th 05 06:07 PM
Challenging Charting	C TO	Charts and Charting in Excel	0	January 17th 05 06:57 PM
decimal point override does not work	Sam Brauen	Excel Discussion (Misc queries)	0	January 6th 05 05:29 PM
Function to automatically insert a new sheet as a result of data entry?	Mark Mulik	Excel Worksheet Functions	2	November 28th 04 02:21 AM

All times are GMT +1. The time now is 06:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us