LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default Need to Customize format of cells!!!!

Please help.

I have a large excel sheet with the columns looking as follows:

A B C D
E

207,803, 209 9 44,946, 2527,571, 296900,873, 291158,381,
210,000, 209 12 44,228, 2527,571, 296899,802, 291156,463,
214,643, 209 19 3,160, 2527,571, 296897,532, 291152,412,
216,818, 209 22 0,637, 2527,571, 296896,466, 291150,516,

What I need to do is make the columns do look like the following but without
have to go to each cell to edit the contents, i.e putting +signs in column A
before last 3digits, putting decimal place in front of the last 3digits in
column B, C, D & E and removing the commas throughout.

There a thousands of these figures that will be inputted on an ongoing basis
so I need to customize each column so only figures need to be inputted and
not various symbols.

0+000 65 18 0.310 Straight 296568.808 290861.845
1+287 65 18 0.310 Straight 296569.977 290862.382
10+000 65 18 0.310 Straight 296577.893 290866.023
12+023 65 18 0.310 Straight 296579.731 290866.869
20+000 65 18 0.310 Straight 296586.978 290870.202

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How do I format cells to show date in Australian not US format? Kevin B[_2_] Excel Worksheet Functions 1 May 12th 08 04:17 AM
Bottom double border from toolbar-customize format not working Tab Excel Discussion (Misc queries) 1 August 16th 06 09:05 PM
how do i format a cell based on format of a range of cells? Chris Hardick Excel Discussion (Misc queries) 2 April 3rd 06 08:54 AM
want format cells alignment not format cells font style Jeannie Bean Excel Discussion (Misc queries) 2 February 10th 06 09:31 AM
Cells won't convert to number format, even after format/cells/num. scottr Excel Discussion (Misc queries) 5 April 12th 05 11:02 PM


All times are GMT +1. The time now is 08:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"